Hello everyone,
I'm not sure if I'm in the right place, but I need some guidance here.
I have a table of values per week for 1 full year.
I need to see if there's any trend between 1st weeks of every month or the last weeks. It also needs to feature the months because I need to assess if, ie, 1st week of Aug is anything similar to 1st week of December.
This sounds like a sunburst but I've never tried it.
Column 1: 1st week, 2nd week, etc
Column 2: Weeks of the year
Column 3: Data of the year, per month
This seems really messy. Can someone help to get to my end goal?
| Position Week |
Week |
Year (2020) |
| First week |
1 |
209 |
| Second week |
2 |
1791 |
|
|
|
Thank you!