Current week v.s. different week previous year comparison (same number of days)
I would like to show sales data for each store comparing one week to a different week in the previous year, provided that the end user can select weeks he want to compare.
My model is quite simple, main fact table and two calendars (islands):
What I'm not able to implement is the following part of the requirement: if the first week selected is the current one, i.e. only monday to tuesday data available since today is wednesday, I need to show sales for the other week up to tuesday and not the whole 7 days.
Moreover, there can be situations in which for store A I have monday and tuesday data, for store B only monday
I've tried with set analysis but I'm stuck on the point where sets are calculated once per chart, so I cannot show someting like this
Re: Current week v.s. different week previous year comparison (same number of days)
Because business users would like to compare sales amount for an even number of days, so if there are only four days of sales in analysis week, I need to show te amount of sales of four days in the comparions week.