14 Replies Latest reply: Mar 9, 2015 12:00 PM by Michael Tarallo RSS

    Calculate trends in bar chart - assistance needed

      I want to calculate revenue per region for future quarters, and  put the results in a bar chart.  From what I've been able to find so far, I think I have to calculate as the data is loaded, not as a calculated dimension while building the chart.  True?    The range functions I think I need don't seem to be available in the list.    Any guidance on steps, or applicable tutorials would be helpful.

       

      Also, I think I need to put forecasted data in different bar chart so I can distinguish....True?  Can't control colors programmatically so the forecasted data looks different?