Usage
week_start_day : monday
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
