Today the extract() function does not support extracting the ‘week number’ from a date field. As a workaround you can use a formula like this (may need some adjustments +/-1 for certain years, could add some ifElse logic to account for that). FYI this uses weeks starting Sun. dateDiff(truncDate("WK…

Nice, that helped a lot! For the week starting on Monday: ifelse( extract("WD", Date) = 1, dateDiff(truncDate("WK", truncDate('YYYY', Date)), Date, 'WK'), dateDiff(truncDate("WK", truncDate('YYYY', Date)), Date, 'WK')+1 ) This can be changed to any day of the week can be used as start…

[image] Jesse: y the extract() function does not support extracting the ‘week number’ from a date field. As a workaround you can use a formula like this (may need some adjustments +/-1 for certain years, could add some ifElse logic to account for that). FYI this uses weeks starting Sun. Hi Je…

It did not seem to work for me. It shows Dec 26, 2022 as Wk53 however it is Wk52. Any ideas? Am i missing something?

Depending on the year you may need to add/subtract 1 from the result. Stay tuned for a new function called WEEKNUM() soon though :wink:

Hey Jesse is there a way I can subscribe to updates to Quick Sight like the WEEKNUM() function? This is something I am looking forward to

Best way for now is you can subscribe to notifications on this page: What's New / Blog - Amazon QuickSight Community Also when you log into Quick Sight you should see a what’s new popup if there are new features.

There’s also this page but I dont think you can subscribe to it: [image] What’s New at AWS – Analytics

Hello @Shokat , Not sure if you already found the answer, even I faced the same issue, I tried the below one and that worked for me. First I created the below calculated field for the week starting from Monday weekmonday addDateTime(1,‘DD’, truncDate(‘WK’,ifelse( extract(‘WD’,{date}) = 1, addDate…

Thanks for posting this solution @Shokat ! :slight_smile:

Thanks a lot, works for me! :slight_smile:

@sushma.sreella That worked for me! Thanks very much.

Week Numbers (1-53)

Learn Technical Articles

Jesse February 14, 2023, 8:37pm 8

There’s also this page but I dont think you can subscribe to it:

Min & Max Dates for a 'Week Number' in a Pivot Table Row

formatDate() gives me an error about unsupported format

Error periodOverPeriodLastValue periodo week

Topic		Replies	Views
Week number in Quick Sight Q&A quick-sight , calculations	2	5467	July 11, 2024
How can I extract number of week from one of my column Q&A formulas , filters , date , weeks , quick-sight , Business-Intelligence-Engineer	4	159	June 10, 2024
Create date parameter in quicksight, if date='week' then extract week_number Q&A quick-sight , calculations , Business-Intelligence-Engineer	1	235	March 1, 2024
How to make date field of week starting on saturday Q&A analysis , formatting , date , weeks , quick-sight , calculations	6	2439	November 21, 2023
Week number starts on Monday instead of Sunday Q&A date , weeks , quick-sight , Business-Intelligence-Engineer	8	1901	November 21, 2023

Week Numbers (1-53)

Related topics