Filter Metrics by Date

If you want to compare facts and metrics at different times or by different dimensions, you can use the Filter by date parameter in their settings.

For example, if you want to compare the number of opened opportunities in the current week and month, add the same fact or metric twice and select a different Filter by date for each instance.

Filter Facts and Metrics by Date

Steps:

  1. Add a fact or metric to the insight.
  2. In the Metrics section, click Filter by date

  3. In the drop-down menu, select the dimension. For details, see section Filter Facts and Metrics by Date With Different Date Dimensions below. 

  4. Select the period by which you want to filter the fact or metric. You can select the current and previous years, quarters, months, and weeks, or a static period (a date range). 

The insight immediately displays the fact/metric in the selected period.

Filter Facts and Metrics by Date with Different Date Dimensions

If your insight contains multiple facts or metrics and you want to use different date dimensions for each of them, specify a different dimension in the date filter of each of them.

The insight then displays the data filtered by the date dimensions that you specified.

In the following image, the insight shows a column chart with the number of opportunities that each sales representative created and closed in the current year.

Date Filter Interactions

You can set a date filter:

  • For individual facts or metrics (Filter by date) in Analytical Designer
  • For  the whole insight (in the top bar) in Analytical Designer
  • For a dashboard in KPI Dashboards

All the date filters include:

  • The period itself (B in the following image), such as last month, three years ago, and a static period (or date range).
  • Date dimension (A in the following image) such as date created, date assigned, and date closed.

When multiple date filters are set, the following rules apply:

  • If the date dimension is the same for all the filters, then only the filter with the highest priority applies as follows:
    1. Fact/Metric filter
    2. KPI Dashboards filter
    3. Insight filter
  • If the date dimensions are different, then all the filters apply at the same time (the AND operator).

Example

The insight shows the trend of how the opportunities that were created last year were gradually closed month by month:

  • The metric filter is set to display opportunities that were created from January 1 to December 31, 2017 (A in the image).
  • The insight filter is set to display opportunities that were closed from January 1 to August 31, 2017 (B in the image).

Since the filters have different date dimensions, the resulting insight applies both filters and shows the number of opportunities that were created and then also closed from January 1 to August 31, 2017.

The following opportunities are NOT included in the displayed data:

  • Opportunity that was created in December 2016 and closed in February 2017 because this opportunity does not fit the metric filter (created in Jan 1- Dec 31, 2017)
  • Opportunity that was created in July 2017 and closed in October 2017 because this opportunity does not fit the insight filter (closed in Jan 1- Aug 31, 2017)