Filter examples

In the past 7 days

users.created_at:
  time_for_duration: [ 7 days ago, 7 days ]

In the past 7 complete days

users.created_at:
  time_for_duration: [ 7 complete days ago, 7 days ]

Is in a date range

Note: End dates are inclusive, so this will include data from 2023-04-30.In use: between_dates

users.created_at:
  between_dates: [ 2023-04-01, 2023-04-30 ]

Before fixed date

In use: before

users.created_at:
  before: 2023-04-01

On or after specific date

users.created_at:
  on_or_after: 2023-04-01

Is on a specific day

In use: is

users.created_at:
  is: 2023-04-01

Is between 1 - 1:59 AM on a day

users.created_at:
  hour_of_day: "1"

Is on Wednesdays

users.created_at:
  day_of_week: Wednesday

First 3 months of 2023

users.created_at:
  time_for_duration: [ 2023-01-01, 3 months ]

Time filters