Applying Filters in Dataset Reports

Dataset Reports can be modified using Filters in the Report Editor.

There are two types of Filters available in the Content tab of the Report Editor. These Filters limit the data that is displayed when viewing the Report online or in Notifications such as Bursts or Digests:

  • Report Filters apply to all of the Report's Elements (Tables, Charts, and linked External Visualizations). These appear as drop-downs that can be adjusted by the Viewer, much like Dimension drop-downs in older versions of Metric Insights.
  • Table Filters apply to a single Table or Chart, are fixed, and can only be modified in the Report Editor.

This article describes types of Filters and how to apply them to the Report.

An Overview of Dataset Report features is available in Dataset Reports Overview article.

Report Filters

1. Open Report Filters Window

Access Reports List, open Report Editor by clicking the necessary Report Active Name Link, and open the Content tab

1.1. Report Built from Snapshot Datasets

  1. A Snapshot Date Filter is created automatically for all Snapshot Reports. Reports built with dates already present in Data do not have this filter.
  2. To add other Report level Filter(s) click [Edit Filters].

2. Define Filters

  1. Select the checkbox near the name of the column that will be filtered to add a Filter.
  2. Click the gear icon in the Filter's row to open the filter editing window.
  3. Change the Filter Label, Filter Type, Sorting type and click [Save].

3. Check the Filters

Table will now be viewed based on the Filter choices in both the Editor and the Viewer.

Table Filters

1. Open Filter Table and Add the Rules

  1. Click Filter Table to open folded section.
  2. Click Add a Rule and add as many Groupings and Rules as you need.
  3. [Apply Changes]

NOTE: Filters set in a Dataset Report will be applied to all of the Report's Elements (Tables, Charts, and linked External Visualizations). These appear as drop-downs that can be adjusted in the Viewer.

Expand or collapse content Example of Filtering for High Values Sales