Configure a Single/Multiple select or cascading filter
Let users filter a dashboard tab on one or more values from a set of choices, such as incident priority. You can have a single or multiple select filter follow another filter in a cascade.
Before you begin
Role required: In the inline dashboard editor: dashboard_admin, or you must be the dashboard owner or have had editing rights shared with you.
In the Filter Designer (): analytics_filter_admin or higher
About this task
Filters apply to data visualizations and simple lists. For the filter to apply to a specific data visualization, it must be based on the same table or indicator breakdown as that visualization. For it to apply to a list, it must filter a field in the list.
On a tabbed dashboard, a filter can apply either to the items in a single tab or to the entire dashboard. For the filter to apply to a single tab, add the filter to that tab. For the filter to apply to the entire dashboard, add it above the tabs.
Procedure
Result
The filter is ready to use when you exit editing mode.
Cascading filters for Manager and Assignment Group
In this example, you want your users to filter incidents by manager or by assignment group. Also, you want to limit the assignment groups that are available in the second filter to those with the manager selected in the first filter.
- You create data visualizations of incidents, such as a single score data visualization of the number of incidents on the Incident [incident] table.
- You create a filter to filter incidents by assignment group manager.
- First, you create a Single select filter labeled Manager.
- You select the User [sys_user] table as the data source. The Manager field is in that table.
- Because you want to apply this filter to a data visualization of Incident table data, you edit the Data to filter field to point to the Incident table and the dotwalked reference field Assignment group.Manager.
- Still under Data to filter, you select Add+ and add the Manager field on the Group [sys_user_group] table. You will need this field later when you set up a cascading filter.
Figure 2. Completed configuration for the Manager filter
- First, you create a Single select filter labeled Manager.
- You create a filter to filter incident data by assignment group.
- First, you create a multiple select filter labeled Group.
- Then you select the Assignment Group field of the Incident [incident] table as the filter source.
Because Assignment Group is a reference field that refers to the Group [sys_user_group] table, the filter source resets automatically to the Group table. The data to filter remains Incident.Assignment Group. -
Scroll down the Group filter's configuration panel to Follow other filters.
-
Under Directly connected filters, you select Follow Manager.
This choice appears because you configured the Manager filter to filter data on the Group table and not only on the Incident table. Remember that to have a cascading filter, the filter that will be followed (in this case Manager) must filter data on the same table as the filter that does the following (in this case Group, on the table sys_user_group).
- Save and exit editing mode.
What to do next
If you have the required roles, add the filter to the filter library. You can also reconfigure, delete, or duplicate the filter. For more information, see Edit a Platform Analytics filter on a dashboard.