Skip to main content

​
Time filters

In use: time_for_duration
users.created_at:
  time_for_duration: [ 7 days ago, 7 days ]
In use: time_for_duration
users.created_at:
  time_for_duration: [ 7 complete days ago, 7 days ]
Note: End dates are exclusive, so this will not include data from 2023-04-30.In use: between_dates
users.created_at:
  between_dates: [ 2023-04-01, 2023-04-30 ]
In use: before
users.created_at:
  before: 2023-04-01
In use: on_or_after
users.created_at:
  on_or_after: 2023-04-01
In use: is
users.created_at:
  is: 2023-04-01
In use: hour_of_day
users.created_at:
  hour_of_day: "1"
In use: day_of_week
users.created_at:
  day_of_week: Wednesday
In use: time_for_duration
users.created_at:
  time_for_duration: [ 2023-01-01, 3 months ]