Skip to main content
Filters time fields by the day of the quarter. Returns rows where the date falls on the specified day of the quarter.

Syntax

<time_field>:
  day_of_quarter: <day_number>

Properties

time_field
string
required
The time/date field to filter on, specified in the format view_name.field_name.
day_of_quarter
number
required
The day(s) of the quarter to filter for. Value must be a number between 1 and 92.

Examples

First day of quarter
users.created_at:
  day_of_quarter: "1"
Not the last day of quarter
users.created_at:
  day_of_quarter: "92"