How to get the monthly data into weekly by week number

[Hemant_rangdal]

here in X axis its in month no. but i need to show in week no. like Week 1, week 2 etc

[sagmukhe]

Hello @Hemant_rangdal - You need to include the Week Number column in your dataset. if your dataset granularity allows you to aggregate the data at a Week Level then you can easily create that “Week Number” column and project that in the X - Axis instead of the Month Number. Hope this helps!

[Hemant_rangdal]

dateDiff(truncDate(“WK”, truncDate(‘YYYY’, {order_date})), {order_date}, ‘WK’)+1
correct??

[sagmukhe]

Hello @Hemant_rangdal - Yes, it would be something like this. There’s already a very good thread on these type of calculations. You can refer to that. Hope this helps!

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

Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!