By default, the first day of the week is Monday when querying an ElastiCube. Sisense has implemented the ISO 8601 standard where the first week of the year is the week in which the majority (four or more) of its days is in the new year.
This means that when selecting filters such as Week 1, Week 2, etc., the first day of the week is not that defined by first day of that year, but rather the first day of the year where there are four or more days in that week. For example, if you select Thursday and January 1, is a Thursday, the first day of the week will be the following Thursday.
You can change the first day of the week so all of your Sisense users’ queries will be calculated according to the day you define as the first of the week.
Note: Changing the first day of week after setting your dashboard or widget filters with weeks might lead to incorrect results. To resolve the issue, the week filter should be removed and added again.
To change the first day of the week:
- In the Sisense Web Application, click ADMIN in the upper right corner and the System Settings tab on the left.
- In the System Configuration page, click Edit.
- From the FIRST DAY OF WEEK list, select the relevant day.
- Click Save.
Hey! Was this article helpful?
Questions? Ask the community.