I need help for this solution. I have a following scenario:
Time Dimension with Date, Year, Month, Week, Day and another table with Date and Value
I'm trying to build a bar chart with this information, selecting a specific date (MonthSelected) the chart will show:
- the average of values for each month for last 3 months (MonthSelected - 3)
- and the average of values for each week until 12 weeks forward
(Month-3) | (...) | (Month-1) | (MonthSelected) | (Next Week) | (Next Week +1) | (...) | (Next Week + 12)
I believe it can be done with calculated dimensions.. not sure... Any help?
Thanks in advance.