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

    Previous Month Reference Line

    Daniel Mann



      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?