week_start_day

Usage

week_start_day: monday
Hierarchy
week_start_day
Default Value
monday

Accepts
A day of the week (monday, tuesday, wednesday, thursday, friday, saturday, or sunday)

Definition

You can adjust the day that Looker considers to be the start of a week with the week_start_day parameter. Using week_start_day affects:

  • The way that data appears in your tables
  • The sort order of the tables
  • The operation of filters

The week_start_day parameter works with three of the four week-related timeframes:

timeframe Works with week_start_day?
day_of_week_index Yes
week Yes
day_of_week Yes
week_of_year No

week_start_day does not work with week_of_year because that timeframe is based on the ISO standard, which uses Monday weeks.

Examples

Adjust weeks to start on Sunday instead of Monday:

week_start_day: sunday