and

Filters based on multiple conditions. Returns rows that meet all specified criteria.

Syntax

<field_name>:
  and:
    - <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.

and

string

required

The and operator. Contains a list of conditions that must be met to be included in the filter results:

Hide conditions

filter_operator

string

required

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

Matches dates in Q1 on the 15th of the month (January, Feburary, March 15)

users.created_date:
  and:
    - quarter_of_year: 1
    - day_of_month: 15