9 Replies Latest reply on Sep 15, 2016 11:37 AM by Alex Braun

    Comparing Number of Records within Rolling 12 Months




      My data is currently using Number of Records to count the number of issues reported by a computer user.


      For example, for the previous rolling 12 months...


      08/01/2015 - 07/31/2016 = 5000 Issues

      09/01/2015 - 08/31/2016 = 4000 Issues


      Now let's say historically since 2011, there have been 150,000 issues. The 5000 and 4000 figures are simply the number within that rolling 12 month period.


      Is there anyway to count the number of issues within a given time frame (rolling 12 months) and compare the change into the next period? Ideally, I would love to be able to have a count of the historical number of issues, count of issues in current rolling 12 months, count of issues in previous rolling 12 months and the percentage change compared to the previous rolling 12 months.