Skip to main content
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>"

​
Properties

​
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:
  • 1 for Q1
  • 2 for Q2
  • 3 for Q3
  • 4 for Q4

​
Examples

Date is in Q1
users.created_at:
  quarter_of_year: "1"
Date is not in Q2
revenue.booking_date:
  not_quarter_of_year: "2"