I’m looking for good solution of the following problem:
I have daily data for sales and I would like to have visualisation in which I can switch between displaying sum(sales) in different time periods (daily, weekly, monthly).
In ideal version I have Date-Range parameter where I can chose the range of dates between which I can see the values and dropdown parameter where I choose time periods (day/week/month).
As an example: it’s 21st of September today and I’ve chosen this month in Date-Range parameter. When on day/week/month parameter I choose:
- “day”, I’ll see 21 bars, one for each day
- “week”, I’ll see 3 bars, one for each Monday this month
- “month”, I’ll see only 1 bar, from the beginning of this month
Much appreciate your hep!