Filter Visualizations by Metric Values

You can filter your data by values of the metrics used in your visualization. For example, you can display data that corresponds to a specific metric value, falls within or outside of a certain interval, or is greater than the specified value.

The filter by metric value is available in all visualizations with at least one attribute or date (in other than the Metrics section) except for headlines. The value is applied after the date and attribute filters.

You can use any local metric (that is, any metric already in your visualization) to filter by its values.

Add a Metric Value Filter to a Visualization

Steps:

  1. In the visualization that you want to filter, click the filter bar dropdown icon.

  2. In the Metric value section, select the metric that you want to use for filtering, and click Apply.

    Analytical Designer adds the metric to the filter bar.

    The filter panel expanded from the filter bar in Analytical Designer. The Avg Check Size metric and the Menu Category attribute are selected.

  3. Click the metric in the filter bar and select one of the logical operators.

    In this example, the user clicked on Avg Check Size. This shows the dropdown menu with metric value filter conditions. The Between option is selected in the list of logical operators.

  4. Specify the values for filtering, and click Apply.

    If your visualization displays data as percentages (the options Stack to 100% or Show in %), you must use the original values when specifying the filter, not the percentages.

    Metric value filter configuration for Avg Check Size using the Between condition. Numeric values 2 and 5 are entered in the input fields. The Treat blank values as 0 option is checked. The Apply button is highlighted in the bottom-right corner of the dialog.

    Analytical Designer now filters your data according to your configuration.

  • When you remove a metric used to filter the visualization, Analytical Designer removes the filter as well.
  • If you remove all attributes and dates from your visualization, the filter by metric value is removed.

The following image shows a visualization before and after the filtering specified above is applied.

Side-by-side comparison of two bar charts showing Avg Check Size by restaurant category and menu category. The top chart includes all data, while the bottom chart is filtered to show only check sizes between 2 and 5. The active metric filter is highlighted above the chart.

Filter Null Values

A null value (null) means that there is no data available. Null values are displayed as dashes (-). Null values are not the same as zero values (0).

When you filter your data and the target values include null values, you can decide whether such values should be included in the final filtered visualization. To include the null values, select the Treat blank values as 0 checkbox.

For example, you have a visualization that displays an average check size ($ Avg Check Size) and the number of owned locations (# Owned Locations) in different states. The visualization is filtered to display only the states with fewer than two owned locations.

  • In this picture, the visualization has a filter with the option Treat blank values as 0 selected and therefore it shows the states with no owned locations (null values are included).

    Metric value filter set to less than 2 with the Treat blank values as 0 option selected. A table shows states where the number of owned locations is fewer than two, including null values represented as dashes.

  • In this picture, the visualization has a filter with the option deselected and therefore shows only the states with at least one location owned.

    Metric value filter set to less than 2 with the Treat blank values as 0 option deselected. A table shows only states with one owned location. States with null values are excluded.
Filter by Attributes or Dates
Use Ranking Filter