Filtering

  • 2 minutes to read

Web Dashboard allows you to filter data in the dashboard items or apply filters to a specific measure. Dimensions and hidden dimensions) are used to build filter criteria.

Filtering_Main

TIP

See Filtering for common filtering concepts for web and desktop applications.

Filter for a Dashboard Item

Filters that applied to a dashboard item affect only to this item. To add filters, open a dashboard item's Binding menu, go to the Data / Filtering section and use Click to set Filter Criteria.

wdd-invoke-filter-editor

This invokes the Filter Editor dialog where you can specify filter criteria:

Filtering_FilterEditor_Empty

TIP

Documentation: Filter Editor

Measure Filter

You can apply filters to individual measures. If you create multiple measures that only differ in applied filters, you can compare values calculated over different date-time periods or against different categories.

Open a dashboard item's Binding menu and select a measure to filter. In the invoked data item menu, open the Filter section and click Edit. This invokes the Filter Editor dialog where you can specify filter criteria.

TIP

Documentation: Filter Editor

You can clear the applied filter in the data item menu's Filter section.

NOTE

The measure filter is technically an expression that uses the filter(summaryExpression, filterCriteria) function where summaryExpression is a measure to be filtered and filterCriteria is a filter. See Expression Constants, Operators, and Functions for more information about functions you can use in dashboard expressions.

The image below shows a Chart with three measures:

  • 2019 - Opened is filtered by 2019 year.
  • 2020 - Opened is filtered by 2020 year.
  • Opened is the original measure without filters.

OLAP Filtering Specifics

You cannot apply filtering by building complex filter criteria in OLAP mode. Filters for a measure are also not supported. Instead, you can filter dimension attributes and hierarchies by selecting the values you want to include or exclude from the dashboard.

Dimension Attribute

Dimension Hierarchy

The Filter Editor contains a list of all values for dimension attributes.

wdd-olap-filtering-attribute

Displays hierarchies as a tree and allows you to filter values at any hierarchy level.

wdd-olap-filtering-hierarchy

See Also