I have been asked to produce a graph which uses the week number as dimension and compares this year to the last.
This is fine but ths business want to adjust the week numbers for last year so the periods align by weekday and (xmas vs xmas) etc.
I have attached the master calendar we are using to show how we would like the offset weeks defined but I am having serious trouble with the set analysis to compare the weeks.
Can anybody provide me with some guidance into how I might achieve this?
All the best,