Timestamp Selection with Start Monday Possible?

Q&A
,
1

Hi,

When I select custom week start Monday, how can I change the timestamp selector also to monday?

{31D951BA-7008-4F23-AD34-B56B663B434B}
{31D951BA-7008-4F23-AD34-B56B663B434B}391×203 7.66 KB

{BE479CB5-790A-4475-BC90-1335A7F8D9FC}

Thanks, Fabian

2

Hello @fabian.altendorfer hope this message finds you well!

In qs, the timestamp selector doesn’t automatically adjust when you set a custom week start. However, you can create a calculated field to align your dates with Monday.
My suggestion is something like this:

truncDate('WK', {your_date_field}, 1)

The 1 at the end makes the week start on Monday.

This way, even though the timestamp selector doesn’t change automatically, your analysis will reflect the custom week starting on Monday.

Please let me know if it help you!

3

Hi lary_andr,

thanks for the information. This function is definitely interesting for us but I’m mainly interested in the possibilities for changing the UI element for the users.

4

Hi @fabian.altendorfer,

Although this is a current limitation in QuickSight (most likely due to the QS timestamp selector and your control being different instances of time selection), I can definitely put this thread up as a feature request so that it can be looked over and potentially be implemented in the future!

1 Like
5

Just to add to the feature request… it may seem alien to many Americans, but I think the majority of the world starts the week on a Monday and not a Sunday. The date picker UI really needs to align with this, it’s a key localisation feature.

2 Likes