Week Start Day

Introduction

By default, Holistics considers Monday as the "start of the week". If this does not suit your organization's definition of week, for example, you want Sunday to be the first day of the week, you can easily change it with our Week Start Day Setting.

You can find this setting in Admin Settings > Week Start Day section:

caution

Changing Week Start Day Settings will affect the underlying SQL queries being generated for every report, thus their results. Please do this carefully and considerately.

How Week Start Day affects your report

This setting will have effect in the following scenarios:

  • Processed date range in Week aggregation
  • Relative week resolution: Resolving text like this week, last 2 weeks into absolute date ranges.

Processed date range in Week Transformation

When you have a date or time field, and you want to report a measure aggregated to Week grain, Holistics will get the week value out of your date-time value, and display the start-end dates of that week. Different Week Start Day settings will produce different processed date ranges:

Week Transformation is used in different places in Holistics:

  • Data model preview, Data exploration:

  • Metric Sheet:

  • Date Drill:

Relative week resolution

The Week Start Day Setting also affects how Holistics resolves "relative week" filter values into actual date range.

For example, given today is 19th August 2019 (Wednesday):

  • If your weeks start on Monday, last week will be resolved into a date range from 10th August 2019 (Monday) to 16th August 2019 (Sunday).
  • However, if your weeks start on Sunday, the result will be totally different.

FAQs

1. I have changed our Week Start Day from Monday to Sunday, but I found nothing changes. What should I do?
After changing your week definition in Admin Settings, please refresh your dashboard cache to apply new week start day.

If the new setting is still not applied, please send us a support ticket via [email protected].

2. Our Holistics account is on version 3.0 but why can't we find this setting in Admin Settings?
Since the new changes may affect your current reports, we are gradually opening this feature to each 3.0 account. However, we expect to release it to all 3.0 accounts on 10 June 2021.
In case you want to try it ealier, please share your case via [email protected]

3. Our Holistics account is on version 2.0 / 2.5 / 2.7. How can we try the Week Start ay Setting?
Currently, we only support this setting on Holistics 3.0 version by default. If you are on other previous versions and want to try our new feature, please share your case via [email protected]