Using the filter dialog in the Prepare room

You use the filter dialog in the Prepare room to define a filter on the dataset and all of the visualizations based on it.

The filter dialog does not support SAP Lumira formula language or regular expressions (regex). You may need to add a calculated measure or dimension to create a more complex filter.

  1. To open the filter dialog in the Prepare room, select the Options gear icon in a column header or for a dimension, and select Filter.

    You can also select the token for an existing dataset filter to edit it in the filter dialog.

  2. On the filter dialog, choose an operator from the list.
  3. Select or type the values to filter:
    • For filters that use the Between operator, type a beginning value and an end value.

    • For filters that use the In List or Not In List operator, select values from the list in the filter dialog.

    Note

    You can hold SHIFT while clicking values to select a range of values.

    You can also select the Options icon to change the filter dialog settings, including displaying the number of times that each record occurs in the dataset, and sorting the data by value or by number of occurrences.

    When filtering an alphanumeric dimension, you can select the Find find icon to search for a member by name.

  4. Select Apply.
The data is filtered and a token representing the filter is added above the Data pane.

You can edit the filter by selecting the token in the Prepare room or Visualize room, or remove it by selecting the Delete icon.