5 Replies Latest reply on Aug 1, 2013 7:42 AM by Joshua Milligan

    Target (reference line) and parameter based on second last value

    Louis Keating

      Hey All,

       

      If I have a target of '20 likes per month', I want the reference line to add 20 to the previous month's total.

       

      In the example below, if the likes per month is 20 (in the parameter), I want the reference line to be at May's Total plus to 20.

      I.e.  278 (258 + 20)

       

      How can I make the reference line show 20 more than the second last month?

       

      Thanks all!

       

      Likes.png