week_start_day

LookML
Version

On this Page
Docs Menu

Go to Model Parameter List

Usage

- week_start_day: monday
a day of the week:
monday
tuesday
wednesday
thursday
friday
saturday
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 3 of the 4 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.

If you do not specify a week_start_day, the default value is monday.

Examples

Adjust weeks to start on Sunday instead of Monday:

- week_start_day: sunday

Still have questions?
Go to Discourse - or - Email Support
Top