18 Replies Latest reply: Aug 15, 2017 1:28 PM by Sujit Gouda RSS

    12M Rolling Chart

    Sujit Gouda

      Can you please help with the below expression


      I have created a bar chart to show data for 12 Month Rolling Period.


      Without any filtering, I see the data rolled for 12 Months correctly.


      But once I start, selecting the values in the Filter the Dashboard doesn't filter correctly to show 12month it selects from the month selected and forward. please help.


      Max(Report Date) = '7/31/2017'




      [Report Year]=,

      [Report Month]=,

      [Report Date]={'>=$(=MonthStart(Max([Report Date]),-11))<=$(Date(Max([Report Date])))'}




      Without Selection:



      With selection on May 17