...
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 |