Week number in QuickSight

[JoseB-aws]

Hello,
This is a great post explaining how to do it:

Week Numbers (1-53)

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", truncDate('YYYY', {order_date})), {order_date}, 'WK')+1