quarter_of_year

Filters time fields by the quarter of the year. Returns rows where the date falls within the specified quarter.

Syntax

<time_field>:
  quarter_of_year: "<quarter_number>"

time_field

string

required

The time/date field to filter on, specified in the format view_name.field_name.

quarter_of_year

number

required

The quarter to filter for:

Date is in Q1

users.created_at:
  quarter_of_year: "1"

Date is not in Q2

revenue.booking_date:
  not_quarter_of_year: "2"

⌘I