1. Modeling
  2. Work with data
  3. Filter data

Use Filter to create filter rules that limit the data you see in a module or 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 NameCompatible 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, Boolean
  • 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.