Please take a look at the solution. I don't think you need any calculation to fix this up. You can do it with the tableau date options which you should be using on the Calendar Date.
Please find the below attached screenshot to verify the same. Also find the attached tableau 10 workbook for the same for reference.
Thanks and Regards,
Appreciate the feedback mate!
To explain my problem we will only evaluate the data for 2016 for now.
- I agree that if we compare the “Reporting Week” Dimension with the “Calendar Date Reporting Week” the production data is the same for each week.
- However, if we introduce a monthly component based on the number of days in that month like in worksheet "Calendar Date Reporting Month" you can clearly observe how the “Calendar Date Reporting Week” for some months cross over between different months which it should not be doing.
- You can also observe the problem in Worksheet “Sheet 2 & 6” for February where Week 10 falls in February and March, there are also clashes in other months of the year
- The table below is a further illustration of how my 2016 weeks are grouped into the respective months:
- I need a calculated field that will group the respective Weeks together to give me the twelve months
- Typically, a formula that will allow me to add, Week 1 to 5 to give me “January” and so on for all the other months of the year
- My workbook is attached, I have also attached the 2016 reporting weeks and months for context on what I am trying to replicate (see attached pdf)
Thanx again for your support Ashish!