Ales
October 13, 2023, 2:04am
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:
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
ErikG
October 13, 2023, 6:28am
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.
Ales
October 16, 2023, 1:39am
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
ErikG
October 16, 2023, 6:54am
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
Ales
October 17, 2023, 3:51am
5
Ales:
MMM D, W
Changing the format from ‘MMM D, W ’ to ‘MMM D, w ’ fixed it.
Thank you anyway!
2 Likes
Thank you for answering so many questions in the Community, @ErikG from our AWS Partner, Woodmark!
ErikG
November 15, 2023, 8:51am
7
@Ales look what i just found.
2 Likes
Ales
November 16, 2023, 12:19am
8
Thank you @ErikG . Is that a new functionality? That’s really helpful
1 Like
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