Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...