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

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 Select the filter type for a workspace dashboard filter.

Role required: In the in-line editor, you must be the dashboard owner or have had editing rights shared with you. In the technical editor, the ui_builder_admin role is required. To save a filter to the library or create a filter in the Filter designer, you need the analytics_filter_admin role.

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.
Single select filter, showing one value being selected.
A Multiple select filter lets users select multiple values of a field or breakdown.
Multiple select filter, showing several values being selected.

Procedure

  1. In Filter source type, select either a Table or an Indicator breakdown.
    MetricBase tables are available under Tables.
  2. 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 from 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.
        Changing the data source to a reference field, which in turn changes the table.
    • 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.
  3. (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

    Checklist of possible table values.

    Available values 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.
  4. (Optional) Select the default value or values for the filter.
    The dashboard applies these values when a user opens the dashboard.
  5. (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 2.
  6. 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.
    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.
    • Many-to-many filters are not supported.
  7. 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.
  8. To let users clear the values they selected for the filter, enable Allow filter clearance.
  9. (Optional) Set the maximum number of elements that are loaded initially and at each page refresh.
    The default value is 500.
  10. Select Save.

Result

The filter is ready to use when you exit editing mode.

Example: Cascading filters for Manager and Assignment Group

Consider a case where 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. To accomplish this, you create a Single or Multiple select filter based on 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 to point to Incident.Assignment group.Manager. You also add the Manager field on the Group [sys_user_group] table as data to filter. You will need this field later when you set up a cascading filter.
    Second filter on the User table data source filtering the dot walked incident - assignment group - manager field.
  3. You create a filter to filter incident data by assignment group.
    1. First, you create a multiple select filter labelled Group.
    2. 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.
    Filter with the Group table as filter source that filters the Assignment Group field on the Incident table.
  4. Remember that you want the user to be able to select groups that they have filtered by manager. For this to happen, the Group filter must follow the Manager filter. To make that cascade possible, the Manager filter must be configured to filter data on the Group table. This requirement is why you added Group.Manager as data for the Manager filter to filter. When you scroll down the Configuration panel to Other filters to follow, you see that indeed the Group filter can follow the Manager filter through a direct connection.
    Other Filters to Follow section of the configuration panel for the Group filter, with a toggle to follow the Manager filter.
  5. You set the Group filter to follow the Manager filter, save, and exit editing mode. 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.
    Dashboard filtered by Beth Anglin as manager, showing only those assignment groups they manage as available to filter by.

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 filter on a workspace dashboard.