Filter Visualizations by Attributes or Dates

To refine the data that your visualization shows, add attribute filters or date filters to the visualization. To do so, add attributes or a date to the filter bar.

You can choose from the following options:

  • Drag and drop attributes or a date from the Data Catalog to the filter bar.
    Analytical Designer enables the filter automatically.

    filter bar

  • Add attributes or a date to the visualization (other than the Metrics section) and enable it in the filter bar dropdown menu. Then, refine your data.

    filter values

  • Select any metric from the visualization in the filter bar dropdown menu. Then, refine your data.

  • Select Top/bottom values in the filter bar dropdown menu. Then refine your data.

Refine the Filters Applied to a Visualization

Steps:

  1. Click the filter name in the filter bar.

  2. Do the following:

    • For attributes, select the options to display or hide.
    • For dates, select the period to be filtered.
    • For metrics, specify the filter. For details, see Filter Visualizations by Metric Values.
    • For top/bottom values, specify the filter.

  3. Click Apply.

refine filter
filter date
filter metric

If you first add an attribute to filter the visualization and then you add unrelated metrics or attributes to the Metrics section, the attribute stays in the visualization but does not filter the data. Analytical Designer displays an informative message.

If your attribute has multiple display labels, you can select the label in the filter definition.

If the attribute has any empty (NULL) values, you can include them in the filter as well by selecting (empty value) in the filter definition.

filter null values

Visualization Date Filters

If you want to filter your visualization by date, in the filter definition you can:

  1. Select the date dimension (the Date as option).
    If you change the date dimension, the Additional filters are reset.

  2. Select the Period from which to filter the data.

    • All time that includes all available data
    • Static period where you specify an exact range including time: 1/1/2022 09:00 - 30/6/2022 17:00
    • Relative period where you specify a range that is relative to today and changes in time: from last week to tomorrow, from 5 hours ago to 2 hours ahead.
    • Predefined periods for minutes, hours, days, weeks, months, quarters, and years relative to today: last 15 minutes, last 2 quarters, this month, last 2 years

  3. Add Additional filters to filter by additional date granularities and attributes, such as day of week or month of year.
    You can add multiple additional filters.

    additional filters

  4. Exclude data from the current period (select Exclude < period >).
    If you want to display average daily revenue from the last 7 days, you exclude today because it contains only incomplete/partial data. The visualization then shows the 7 days before today.

    exclude filter

  5. Compare data to another period (the Compare the period with option). For details, see Time over Time Comparison.

The time format (12h or 24h) is based on your operating system settings.

The following image shows a date filter that filters to workdays (Monday to Friday) in the current quarter and compares the data to the same period of the previous year.

date filter

Multiple Date Filters

Adding multiple date filters to a visualization can significantly enhance its interactive time-based analysis capabilities. For instance, it’s possible to configure the visualization to only show data for leads generated within a certain period, like the past year, and then further refine it to display only those closed within a different timeframe, such as the last quarter.

However, similar to how attribute filters cannot apply the same attribute more than once, each date filter introduced must correspond to a distinct date dimension.

Comparisons of data across different time periods can only be conducted using the primary (leftmost) date filter in the visualization.

In the context of charts that offer recommendations for next steps, such as bar charts, these suggestions are generated based solely on the first date filter.

Multiple date filters are also compatible with dashboards. For detailed instructions on their application, refer to the Use Date Filter on Dashboards section.

Disable a Filter for a Visualization

To disable a filter, drag the filter from the filter bar and drop in to the Data Catalog, or unselect it in the filter bar dropdown menu..

Filter By Metric Values