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