Use Filter to create filter rules that limit the data you see in a module or classic dashboard.
A filter rule consists of an operator, a modifier, and a valid data type.
The operators you can use in a filter vary with each data type. Only operators that are valid for a particular data type are available for selection. This is summarized in the table below.
Operator Name | Compatible Data Type |
Contains displays items that contain the text string you enter. | Text |
Starts with displays only items that start with the text string you enter. | Text |
Ends with displays only items that end with the text string you enter. | Text |
Is blank searches for cells that contain no data. | Text, Date, Time period, List |
Is not blank returns all cells that contain data. | Text, Date, Time period, List |
Is equal to displays items with a value equal to the value you enter. | Text, List, Number, Date, Time period, Boolean |
Is not equal to displays items with a value that is not equal to the value you enter. | Text, List, Number, Date, Time period, Boolean |
Is greater than displays items with a value greater than the value you enter. | Number, Date, Time period |
Is greater than or equal to displays items with a value greater than or equal to the value you enter. | Number, Date, Time period |
Is less than displays items with a value less than the value you enter. | Number, Date, Time period |
Is less than or equal to displays items with a value less than or equal to the value you enter. | Number, Date, Time period |
Some operator and data type combinations allow multiple values to be entered as modifiers.
For example, if your data type is a Time period and your operator is set to Is equal to, you can enter multiple months or years in the modifier box. The filter will display all items that include a time period equal to the months or years you enter.