16 Replies Latest reply: Aug 25, 2016 12:08 PM by Sunny Talwar RSS

    Previous Month Reference Line

    Daniel Mann

      Hello,

       

      I have a Gauge that shows AVG(Score), and I want to add a reference line that shows the Avg(Score) from the previous month.

       

      I am selecting Month from a Date field in the table using Month(Date).

       

      I have tried =AVG({<Month={$(=Max(Month(Date))-1)}>} [Score]) but this is not working and gives me the current month score.

       

      Any ideas?