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