9 Replies Latest reply: May 19, 2017 7:49 AM by Sunny Talwar RSS

    6 Month Rolling Within 12 Month Rolling

    Matthew Quinn

      Hi there,


      I am working on a bar chart that counts a number of issues raised and shows it for the last 12 months (starting from the previous month). So for example, this month is May 2017; this means the bar chart will show from April 2017, going back to May 2016.


      Within each bar representing the months, I want to see the count of issues for the past 6 months - April 2017 should show a total of the count of issues for April, March, February, January, December, November. and then the same pattern for the other 11 months.


      So far my set analysis is as follows to achieve the 12 month rolling (Static) chart:


      COUNT(DISTINCT{1<NM_IncEventDate={'>=$(=MonthStart(AddMonths(Max(NM_IncEventDate),-12))) <=$(=MonthEnd(AddMonths(Max(NM_IncEventDate),-1)))'}>}NM_ID)


      This only counts for each individual month, so how do I get each month within this 12 month range, to total up the last 6 months performance?


      I have also attached a photo of the graph so far, below:



      Thank you