6 Replies Latest reply on Dec 1, 2017 5:39 AM by Paul.Labuda

    Rolling last X months into last bucket and calculate it.

    piotr.biaka

      Hi Guys,

       

      I'm trying to find out, whether it is possible to roll last X months from data set into last 'cell'.

      We have a data set from last 365 days. Note that we have have more than 1 record per day.

      What we would like to achieve is to have a parameter with the following integers: 2, 3, 6. Based on this parameter, we would like to roll last 2, 3, 6 into last month and calculate an average of all values.

      I have attached an excel file with data set and some comments. I'd appreciate your advice.

      Thanks!

      Rolling_Dataset.png