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.
- To open the filter dialog in the Prepare room, select the
Options
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.
- On the filter dialog, choose an operator from the list.
- 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
icon to search for a member by name.
- 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.