0 Replies Latest reply: Nov 22, 2011 7:11 PM by tomjerry RSS

    Bar Chart with calculated dimension (Month/Week)

      Hi,

      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.