I am looking to do 2 different measures which gives me the following: -
- for each date, I want to see the last 7 days of sales
- for each date, I want to see the last 30 days of sales
Example: - Today, I want to see that yesterdays date contains the count of sales for (22nd, 21st, 20th, 19th, 18th, 17th & 16th) which would then mean that 21st date would contact count of sales from 21st - 15th) - Of course the other measure should be doable by amending this one.
The below is what I am hoping for - dont have any sample data yet im afraid.
3 measures in total - yesterday which is fine. Then last 7 days and last 30 days. So looking at yesterdays date on the 'x' axis it gives sum of sales from yesterday, last 7 days from yesterday and last 30 days from yesterday.