Week start day inconsistency between calculated field and filter in Quick Sight

Q&A
, , , , , ,
1

Hi everyone,

I’ve recently updated my Quick Sight analysis to start the week on Monday.
To achieve this, I created a calculated field that returns the start of the week. When I add this calculated field to a visual, it correctly shows the Monday of each week as expected.

However, when I create a filter using this same calculated field, the filter doesn’t seem to respect the “week starting on Monday” rule — the available values in the filter are different from the ones shown in the visual.

Has anyone experienced this issue before?
Is there a way to make the filter reflect the same “week start on Monday” logic as the calculated field?

Thanks in advance for any help!

where v_week:
toString(formatDate(truncDate(“WK”, dt),‘dd-MMM-yyyy’))

image
image538×516 47.1 KB

2

Hi @arthurfsc and welcome to the Quick Sight Community!
You can adjust the start of the week through the Analysis Settings menu, this should change throughout your analysis to avoid having to use calculated fields:

image
image360×563 38.7 KB

3

Hi Brett, Thanks for your reply.

I did this when I sent the screenshot. It looks like a bug of Quick Sight, like the filters doesn’t recognize the this settings, since if I add this calculated field of week truncate, the table shows Monday. However if I put the same column as filter, the quicksight shows Sunday (As you can see in my screenshot)

4

Hi
You need to create two calculated fields

Weekdays name
”//Formula to extract the day of the week from date //

ifelse( extract(‘WD’,{cest_date})= 1,‘Sunday’,

extract(‘WD’,{date})= 2,‘Monday’,

extract(‘WD’,{date})= 3,‘Tuesday’,

extract(‘WD’,{cest_date})= 4,‘Wednesday’,

extract(‘WD’,{date})= 5,‘Thursday’,

extract(‘WD’,{date})= 6,‘Friday’,

extract(‘WD’,{date})= 7,‘Saturday’,

null)”

image
image262×204 7.12 KB

1 Like
5

Hi @arthurfsc,

Following up here to see if you had any additional questions or if the last response helped with a work around for your case?
Let me know if you have any additional questions, if we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

6

Hi Brett, Thanks for your support. To overcome this issue I had to create the column week (Monday - Sunday) in the dataset. It looks a QuickSight limitation, even the dashboard setup the start of week as Monday, if we put this calculated field in the filter control, it doesn’t recognize as Monday and still as Sunday. You can close now this topic.

@Shahid_Muhammad Thanks for your suggestion, very smart. Unfortunately, in my case where I need calculate the average of the week (starting on Monday) this suggestion doesn’t fit exactly my needs.

2 Likes