---
sourceDocument: Xanadu Platform Analytics
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/now-intelligence
Release :
- xanadu
ft:locale :
- en-US
ft:publication_title :
- Xanadu Platform Analytics
ft:clusterId :
- par
bundleId :
- par
workflow :
- Platform
---
# Configure a Single/Multiple select or cascading filter
# Configure a Single/Multiple select or cascading filter {#ariaid-title1}
* Release version: Xanadu
*
* Updated August 1, 2024
*
*  7 minutes to read
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
Important:
This procedure assumes you've created a filter in the Filter designer or added a filter to your dashboard with the Single select or Multiple select filter type. See [Create or add a filter on an inline dashboard](https://servicenow-prod.fluidtopics.net/0thTiNrf5lrX6UD~pTwNtA "Create a filter or select one from the filter library. When creating a filter, name it, and choose whether to create a single select, multiple select, date, or true/false filter.") or [Create a filter in the Filter Designer](https://servicenow-prod.fluidtopics.net/~VGMFTb4LlClO4M0Sxyw5g "Create a Platform Analytics filter in the Filter Designer and add it to the library for reuse.").
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 (LibraryFiltersNew): analytics_filter_admin, admin
## 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.
A Single select filter lets users filter items by one value.
A Multiple select filter lets users select multiple values of a field or breakdown.
## Procedure
1. Create a filter and select the Single or Multiple Select filter type, as described in [Create or add a filter on an inline dashboard](https://servicenow-prod.fluidtopics.net/0thTiNrf5lrX6UD~pTwNtA "Create a filter or select one from the filter library. When creating a filter, name it, and choose whether to create a single select, multiple select, date, or true/false filter.") or [Create a filter in the Filter Designer](https://servicenow-prod.fluidtopics.net/~VGMFTb4LlClO4M0Sxyw5g "Create a Platform Analytics filter in the Filter Designer and add it to the library for reuse.").
2. In Filter source type, select either a Table or an Indicator breakdown.
MetricBase tables are available under Tables.
3. Specify the filter source, depending on source type.
* If you selected the Table type, select the table and the field.
Note:
* You can select only reference fields and fields that have a Choice list. If the table has only non-reference string and numeric fields, you do not have any fields to select from.
* If you select no field, you can filter only data on that table or in reference fields that point to that table. For example, if you select the Company table as your filter source, you can only filter the Company table or reference fields pointing to Company, such as Incident.Caller.Company or Incident.Location.Company.
* If you select a MetricBase table, don't select a field.
* If you select a field that is a reference field to another table, the filter source resets to refer to that table with no field selected. The data to filter is set automatically to the reference field that you originally selected. As additional data to filter, you can set only the table in the filter source or other reference fields pointing to that table.
{#create-select-filter-workspace__ul_rbc_xs2_2xb}
* If you selected the Indicator breakdown type, select an indicator breakdown.
Important:
* You can only select a breakdown that is used by at least one indicator.
* Scripted breakdowns on data visualizations are not supported.
* Only two levels of breakdown can be applied to an indicator at the same time. On a dashboard, this could be two filters or one filter and a breakdown specified in the data visualization.
{#create-select-filter-workspace__ul_gcb_jvh_yyb}
{#create-select-filter-workspace__choices_qlx_jhl_pvb} {#create-select-filter-workspace__step_filter-source}
{#create-select-filter-workspace__step_filter-source}
4. **Optional:** To limit the values that the runtime user can choose to filter by, select Configure values (number).
A list of possible values opens. Clear a value to prevent runtime users from filtering by it.Figure 1. Configure values list and resulting choices in runtime
Note:
If the filter source is a reference to a table, you don't have a list of values to configure. Instead, you can build a condition to set the values in the filter. You can also set a related list condition.
5. **Optional:** Select the default value or values for the filter.
The dashboard applies these values when a user opens the dashboard.
6. **Optional:** Select the data to filter.
Some data to filter is chosen automatically depending on the filter source. For example, if you select the Category indicator breakdown from the Incident.Category breakdown source, the filter automatically filters the Category field on the Incident table and any indicators with the Category breakdown. You can edit the automatic data selection or add more data to filter.
Note:
Your selection of filter source can impact which data you can filter. For more information, see Step [3](https://servicenow-prod.fluidtopics.net/yVymizSPEvjsu60p3X9Lhg#create-select-filter-workspace__step_filter-source).
7. Under Other filters to follow, if the conditions are met, you can select another filter for the current filter to follow in a hierarchy, creating a cascade.
Note:
You can only set Other filters to follow when you are configuring filters on a dashboard, not from the filter designer.
When you set the filter to follow another filter, the choices available in the following filter are limited by the choices made in the followed filter. For more information, see the example [Cascading filters for Manager and Assignment Group](https://servicenow-prod.fluidtopics.net/yVymizSPEvjsu60p3X9Lhg#create-select-filter-workspace__example_pnj_s4m_4xb).
Conditions:
* You can follow a filter only if Pill is the UI element for that filter.
* Only Table and Indicator Breakdown filters support cascading filters.
* The filter to be followed must filter data on the same table as the filter source of the following filter.
{#create-select-filter-workspace__ul_oyr_ft5_vxb}
Note:
* Some filters have a many-to-many relationship, where values on both filters can match multiple values on the other filter. One such filter can follow another only through a connecting table. Only admins can set up these cascading filters. For more information, see [Set a filter to follow another filter in a many-to-many relationship](https://servicenow-prod.fluidtopics.net/Axi~EJ6~vu6F8X8IPZuF9A "In some cases, values on a pair of filters can refer to multiple values on each other. For one such filter to follow another, it must go through a connecting table.").
* Two filters can follow each other, but there are additional requirements. For more information, see [Conditions for two filters to follow each other](https://servicenow-prod.fluidtopics.net/jC95QDDtQOcaRT5E9Q_5VQ "It is possible to set up two filters to follow each other mutually. However, several technical limitations apply.").
{#create-select-filter-workspace__ul_hjj_st4_11c}
8. Select the Sort direction.
If you select Ascending, the lowest filtered values are shown first. If you select Descending, the highest values are shown first. The user can change this value.
9. To let users clear the values they selected for the filter, enable Allow filter clearance.
10. **Optional:** Set the maximum number of elements that are loaded initially and at each page refresh.
The default value is 500.
11. Select Save.
## Result
The filter is ready to use when you exit editing mode.
## Cascading filters for Manager and Assignment Group {#create-select-filter-workspace__example_pnj_s4m_4xb}
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.
1. You create data visualizations of incidents, such as a single score data visualization of the number of incidents on the Incident \[incident\] table.
2. You create a filter to filter incidents by assignment group manager.
1. First, you create a Single select filter labeled Manager.
2. You select the User \[sys_user\] table as the data source. The Manager field is in that table.
3. 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.
4. 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.
{#create-select-filter-workspace__ol_okt_3qx_mgc}Figure 2. Completed configuration for the Manager filter
3. You create a filter to filter incident data by assignment group.
1. First, you create a multiple select filter labeled Group.
2. Then you select the Assignment Group field of the Incident \[incident\] table as the filter source.
{#create-select-filter-workspace__ol_o5f_2f2_b1c}
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.
4. Scroll down the Group filter's configuration panel to Other filters to follow.
5. Under Directly connected filters, you select Follow Manager.
![Other Filters to Follow section of the configuration panel for the Group filter, with a toggle to follow the Manager filter.]()
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).
6. Save and exit editing mode.
{#create-select-filter-workspace__ol_vfr_dzd_b1c}
Later, a dashboard viewer selects Beth Anglin in the Manager filter. Then, when selecting assignment groups in the Group filter, only those groups with Beth Anglin as the manager are available.
## 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](https://servicenow-prod.fluidtopics.net/94dN5ZOMisADiVnJdOfImw "When you highlight a filter on a dashboard that you have put into edit mode, you have several editing options depending on whether the filter is local to the dashboard or saved in the library.").
* **[Set a filter to follow another filter in a many-to-many relationship](https://servicenow-prod.fluidtopics.net/Axi~EJ6~vu6F8X8IPZuF9A)**
In some cases, values on a pair of filters can refer to multiple values on each other. For one such filter to follow another, it must go through a connecting table.
* **[Conditions for two filters to follow each other](https://servicenow-prod.fluidtopics.net/jC95QDDtQOcaRT5E9Q_5VQ)**
It is possible to set up two filters to follow each other mutually. However, several technical limitations apply.
**Related concepts**
* [Applying filters to Process Mining maps](https://servicenow-prod.fluidtopics.net/VYPYuk6EWTPvLaCbrBsUzA "If a dashboard filter is on the same table as the breakdown of a process project, that filter can apply to a Process Mining map of that project.")
**Related tasks**
* [Create or add a filter on an inline dashboard](https://servicenow-prod.fluidtopics.net/0thTiNrf5lrX6UD~pTwNtA "Create a filter or select one from the filter library. When creating a filter, name it, and choose whether to create a single select, multiple select, date, or true/false filter.")
* [Create a filter in the Filter Designer](https://servicenow-prod.fluidtopics.net/~VGMFTb4LlClO4M0Sxyw5g "Create a Platform Analytics filter in the Filter Designer and add it to the library for reuse.")
* [Create a filter on a technical dashboard in UI Builder](https://servicenow-prod.fluidtopics.net/JyUuRAjLX8MzauPuYcS93g "To filter data visualizations and simple lists in a technical dashboard, add a filter component in UI Builder and configure event handlers.")
* [Make a data visualization act as a filter](https://servicenow-prod.fluidtopics.net/W8NWMgbyvJiSn6czAm2Pfw "You can set a data visualization to act as a filter on a dashboard that contains it. Only table or indicator data can be so filtered.")
* [Configure a True/False filter](https://servicenow-prod.fluidtopics.net/QrpfPzieuXH3HeEaQ5E5fQ "Let users filter on true/false fields and breakdown elements. For example, you can enable users to choose only the incidents where the Active field is set to true.")
* [Configure a Date filter in the inline editor](https://servicenow-prod.fluidtopics.net/2LL5tp7D6qb7gTt_AcHjBA "Let users select predefined periods or specify custom start and end dates for the data on a dashboard tab.")
* [Create a domain filter](https://servicenow-prod.fluidtopics.net/oU5whQkvpXtgiLIkPH~kRw#create-domain-filter "Create a domain filter so that you can filter data visualizations on domains in a domain-separated instance. Domain filters enable the user to see data associated with one or more domains.")
* [Edit a Platform Analytics filter on a dashboard](https://servicenow-prod.fluidtopics.net/94dN5ZOMisADiVnJdOfImw "When you highlight a filter on a dashboard that you have put into edit mode, you have several editing options depending on whether the filter is local to the dashboard or saved in the library.")
* [Troubleshoot breakdown filters](https://servicenow-prod.fluidtopics.net/KXd~8V72dkaXPdwUqS~7JQ "In Platform Analytics experience, it's not possible to do extend the functionality of a migrated breakdown filter that doesn't have an associated indicator.")
*[\>]: and then