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 |
|---|---|
Equal to | Filters charts and tables to show values that match the specified value only |
Not equal to | Filters charts and tables to show all values that do not match the specified value |
Greater than | Filters charts and tables to show values greater than the specified value. The specified value 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 value. The specified value itself will also be included |
Less than | Filters charts and tables to show values less than the specified value. The specified value itself will be excluded - only values less than this will be shown |
Less than or equal to | Filters charts and tables to show values greater than or equal to the specified value. The specified value itself will also be included |
In | Filters charts and tables to show values that match one or more specified value |
Not in | Filters charts and tables to show values that do not match one or more specified value |
Like | |
Not like | |
Between | Filters charts and tables to show all values that are between two specified values |
Not between | Filters charts and tables to show all values that are not between two specified values |
Is null | |
Is not null | |
Starts with | |
Ends with |
Add Comment