Creating
s with filtersThis guide explains how to create
s with filters.Introduction
Filter data in dashboards to display only the information that you find relevant.
s andConcept
There are two types of filter:
-
filters
Use
filters to filter data at the level of individual s. This procedure is explained in this guide. -
Dashboard filters
Use dashboard filters to filter data at the level of dashboards and dashboard pages. For more information, see Adding filters to a dashboard.
For more information about the different ways to filter data in Data Explorer & Dashboards, see Filtering data on a dashboard.
Prerequisites
Before you complete the procedure in this guide, perform all of the following actions:
Adding a dimension filter to a
To add a dimension filter to the s, follow these steps:
-
Select the workspace you work with in Adverity and then, in the , click Data Explorer.
-
At the top of the page, select the View tab that contains the .
-
In the Widget filters section, click Add dimension filter.
-
(Optional) Deselect the Use date range checkbox to filter data based on dimension values for all time.
-
In the Choose dimension drop-down menu, select a dimension by which you want to filter data.
-
In the Filter by drop-down menu, select the dimension values for which you want to filter the dimension. For more information, see Changing dimension filter criteria.
-
(Optional) Select the Exclude checkbox to exclude data matching the filter.
-
To add another dimension filter, click Add filter and repeat steps 2-5 above.
-
Click Apply.
For more information about dimension filters, see Advanced dimension filter configuration.
Adding a metric filter to the s
To add a metric filter to the s, follow these steps:
-
Select the workspace you work with in Adverity and then, in the , click Data Explorer.
-
At the top of the page, select the View tab that contains the .
-
In the Widget filters section, click Add metric filter.
-
In the Choose metric drop-down menu, select a metric by which you want to filter data.
-
Select the filtering condition from the following options:
-
At least - use this option to select data only if the metric value is greater than or equal to the condition.
-
At most - use this option to select data only if the metric value is less than or equal to the condition.
-
Range - use this option to select data only if the metric value is within the range specified in the condition.
-
Special - use this option to select data based on NULL values for this metric.
-
-
In the From field, enter the lower bound for the values.
-
In the To field, enter the upper bound for the values.
-
For the Special condition type, select the option to include or exclude NULL values.
-
Click Apply.
For more information about metric filters, see Advanced metric filter configuration.
Video guide: How to apply advanced filters in Adverity
This video guide explains how apply permanent filters, dashboard filters and filters in Adverity.