Filter Comparison Operators

There are a number of different comparison operators in the Dashboard, some are more obvious than others, so we’ve put together the following table that explains how each of then can be used.

Comparison Operator	Meaning

Comparison Operator	Meaning
Equal to	Filters charts and tables to show data that exactly matches the specified option
Not equal to	Filters charts and tables to show data that does not exactly match the specified option
Greater than	Filters charts and tables to show data greater than the specified option. The specified option itself will be excluded - only values greater than this will be shown
Greater than or equal to	Filters charts and tables to show values greater than or equal to the specified option. The specified option itself will also be included
Less than	Filters charts and tables to show values less than the specified option. The specified option itself will be excluded - only values less than this will be shown
Less than or equal to	Filters charts and tables to show values less than or equal to the specified option. The specified option itself will also be included
In	Filters charts and tables to show values that match one or more specified options
Not in	Filters charts and tables to show values that do not match one or more specified options
Like	When ‘Like’ is selected and users enter a string e.g. ‘co’, all charts and tables will be filtered on words that contain that string - results could include New Mexico or Wisconsin. This differs to ‘Equal to’ as this search will only find data that is an exact match for the string
Not like	When ‘Not like’ is selected and users enter a string e.g. ‘co’, all charts and tables will be filtered on words that do not contain that string - results could include Alabama or Illinois. This differs to ‘Not equal to’ as this search will only find data that is not an exact match for the string
Between	Filters charts and tables to show data that is between two specified values
Not between	Filters charts and tables to show data that is not between two specified values
Is null	This option will filter charts and tables to show null values only
Is not null	This option will filter charts and tables to show values that are not null
Starts with	This option will match any values that start with the provided string. For example, Starts with ‘Co' would find matches such as Colorado and Connecticut
Ends with	This option will match any values that end with the provided string. For example, Ends with ‘Co' would find matches such as New Mexico