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 
Create a Mobile Website
View Site in Mobile | Classic
Share by: