In Explore, you can decide which day of the week should be considered the start of the week when it comes to the reports you build and the filters you use. The ability to set a custom start of week gives you more flexibility in weekly reporting.
This article contains the following topics:
Understanding the default start of week
Setting a custom start of week
If this default behavior doesn’t suit your needs, Explore administrators can set an account-wide start of the week. It can be any day of the week, and it will be applied to all users on your account.
The screenshot below shows a report in an account where the start of the week has been set to Tuesday.
To change the start of the week
- In Explore, click the admin icon ().
- In the menu at the top of the page, click the account information icon ().
- Under Start of the week, select the day of the week that should be considered the first day of the week in queries and filters.
- Click Update account.
When this setting is updated, it is automatically applied to reports in your account, but not to dashboard filters. To apply the custom start of the week to dashboard filters, you’ll need to re-publish your dashboards.
Additionally, this setting has no effect on prebuilt dashboards. However, it does affect copies of the prebuilt dashboards that you've made.
Understanding how the start of week affects week numbers
Setting a custom start of week affects how Explore calculates the week numbers for the year. When you set a custom start of week, week 1 always includes the fourth day of the week. For example:
|Start of week||Week 1|
|Sunday||The week with the first Wednesday of the year|
|Thursday||The week with the first Sunday of the year|
|Saturday||The week with the first Tuesday of the year|
This affects Week of year attributes (for example, Tickets created - Week of year).