Week number starts on Monday instead of Sunday

Question & Answer
, ,
1

Hello everyone,
reading around seems like weeks start on Sunday in QS.
According to that, October 8, 2023 (Sunday), should belong to week #41

On my analysis, I have a date field with daily values. I aggregated it by Week and set a custom format to MMM D, W. This is the result:

Screenshot 2023-10-13 105211
Screenshot 2023-10-13 105211969×53 2.1 KB

As you can see, October 8 is considered under week #40. Shouldn’t QS visualize 41 instead of 40? How can I make it visualize the actual value (41)?

Thank you

2

Hi @Ales,
i would say QS is doing the weeks by ISO 8601. ISO calender weeks starting on Monday.
Maybe you can calculate a new week field based on the weekday.
BG.

3

Thank you @ErikG ,
do you know if is possible to change it? Maybe from some settings? I prefer having the week starting from Sunday as I’m using the dateDiff function at week level

4

Hi @Ales ,
I dont know.
Would it be a workaround for you to use a field “date-1” to get the “right” week?
BG

5

Changing the format from ‘MMM D, W’ to ‘MMM D, w’ fixed it.
Thank you anyway!

2 Likes
6

Thank you for answering so many questions in the Community, @ErikG from our AWS Partner, Woodmark! :slight_smile: :rocket:

7

@Ales look what i just found.

grafik

2 Likes
8

Thank you @ErikG . Is that a new functionality? That’s really helpful

1 Like
9

Hi all, yes we are currently support custom week start as an out-of-box feature. Please try and let us know if any feedback. Thanks!

1 Like