ISOWEEK Calculation

Hi,
As might be known, there is a feature in tableau that calculates the number of week of year in that particular datetime value. (i.e. 25.07.2022 → W30)

May I ask how this ISOWEEK based calculation can be applied in AWS Quicksight? (ISO-8601 Week Based)
Many thanks in advance for your support.
Best Regards.

Hi Emrekyk

First you need to create ISO year and after that ISO week number and on the basis of this you were able to create iso week

Hi @EmreKyk,
It’s been awhile since we last heard from you. Were you able to come up with a solution for your original topic or do you have additional questions?
If still looking for additional help, maybe check out this article to see if it can assist any further.

If we do not hear back within 3 business days, I’ll go ahead and mark as solved.

Thank you!

Hi @Emre_Bulbul, hope this post helps:

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!

1 Like

Hi, Xclipse, @Brett , @Shahid_Muhammad
sorry for late reply! Unfortunately it’s not resolved yet. Let me explain why.

@Brett For this link

  • How can we know which day was the starting day of week for each year?

@Shahid_Muhammad If there is any documentation or link for ISO Year calculation, I’d be so glad if you could share.

Many thanks in advance for your time and help.
Best.

Hi @EmreKyk, please see if this demo helps:

https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Calculation-Custom-Week-Start-Day