Filters in Dashboards

You can filter dashboards by date or any attribute available in your workspace. These filters apply to all KPIs and insights on the dashboard.

Date filters

For details, see Date Filters in Dashboards.

Attribute filters

To filter by attributes, drag and drop Attribute filter to the filter bar at the top and select an attribute from the dropdown menu.

If the attribute has multiple labels, click the filter name, then Configuration and select the label in the Display values as. 

To change the order of the filters, drag a filter to a new position in the filter bar.

To change the filter name, click Configuration in the opened filter, set a new name and Save. To display the original filter name, click the filter and hover your mouse over the question mark icon. To change the name back to the default one, click Reset in the filter configuration.

To delete the attribute filters, drag the filters back to the sidebar or use the remove button in their dropdown menu.

Dependent attribute filters

If you have multiple attribute filters with many items, you can configure the filters to create a hierarchy. Filters then show only the items that correspond with the selections in their parent filters.

Steps:

1. Open a dashboard for editing.
2. Add attribute filters to the filter bar.
3. For each attribute to display items filtered by another attribute, click the filter and then click Configuration. 
   
   
4. In the Filter by section, select a parent attribute filter. You can select multiple parent filters. 
   
   
5. If there are multiple connections between the attributes, select one in the dropdown menu.
   
   
6. Click Save.

Now if you narrow the selection in the parent filter, the dependent filters show only items corresponding with the parent filter selection.

To connect filters, their associated attributes must be connected in the logical data model. If the attributes are not connected, the option to connect them is disabled in the filter configuration.

You cannot connect a parent filter back to the child. This applies also to connections through other filters as well. For example, if you filter Menu Category by Restaurant Category, you cannot configure Restaurant Category to be filtered by Menu Category. 

Example

You have two attribute filters on your dashboard: Restaurant Category and Menu Category.

Menu Category is filtered by Restaurant Category (Restaurant Category is a parent filter of the Menu Category).* 

You narrow the Restaurant Category to display only Casual Dining. The Menu Category then displays only a limited set of items that correspond with Casual Dining.