or - Omni Docs

Filters based on multiple conditions. Returns rows that meet at least one of the specified criteria.

Want to create or conditions between multiple columns? Refer to the Filtered measures guide for an example.

Syntax

<field_name>:
  or:
    - <filter_operator>: <value>
    - <filter_operator>: <value>

field_name

string

required

The field to filter on, specified in the format view_name.field_name. Can be a time, numeric, or string field.

string

required

The or operator. Contains a list of conditions, of which at least one must be met to be included in results:

Hide conditions

filter_operator

string

required

A filter operator such as before, greater_than, etc. and its corresponding value.

Matches dates between January 1-7 and February 1-7, 2025

users.created_at:
  or:
    - between_dates: [ 2025-01-01, 2025-01-07 ]
    - between_dates: [ 2025-02-01, 2025-02-07 ]

Matches California, empty, or null values

users.state:
  or:
    - is: California
    - is: ""              ## "is empty" in the UI
    - is: null            ## "is null" in the UI