Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.omni.co/llms.txt

Use this file to discover all available pages before exploring further.

Filters time fields by the day of the week. Returns rows where the date falls on the specified day of the week.

Syntax

<time_field>:
  day_of_week: "<day>"

Properties

time_field
string
required
The time/date field to filter on, specified in the format view_name.field_name.
day_of_week
string
required
The day of the week to filter for. The value can be either the full name of the day or a number:
  • 0 - Sunday
  • 1 - Monday
  • 2 - Tuesday
  • 3 - Wednesday
  • 4 - Thursday
  • 5 - Friday
  • 6 - Saturday

Examples

Day of week is Monday
users.created_at:
  day_of_week: "Monday"
Day of week is not Sunday
users.created_at:
  not_day_of_week: "0"