10 Replies Latest reply on Jan 15, 2013 7:50 AM by Jonathan Drummey

    % difference using a calculated field and a date filter

    Michael Nealey

      The key metric I'm looking at here is the moving average of the profit ratio.

       

      Thanks to a nice date filter, I am displaying only 2011 through 2012, but my moving average calculation takes into account data points before 2011 - so my January 2011 moving average score is different to my actual January 2011 profit ratio.

       

      What I would like to do now is display a % difference in the moving average profit ratio with January 2011 as the baseline and the % difference being the difference from January 2011.

       

      Unfortunately the only calculation I seem to be able to perform that does a % difference looks at the entire table...i.e. at the data I have hidden with my date filter...