6 Replies Latest reply: Oct 12, 2017 11:36 AM by Lorenzo Conforti Andreoni RSS

    Rolling 30-day Average

    siva bose

      Hi Guys,

       

      I need to find rolling 30-day average based on the date but need to do achieve this in the script (not by using expressions).

       

      Attached the sample data, which has file name, file size, file date and file type. File Name has two file types. I need to get the rolling 30 day file size average with respect to selections.

       

      Alo I need to create a flag by comparing the normal average and Rolling 30-days average.

       

      (If Normal avg >= Rolling 30-days avg then 0 otherwise 1) - Flag - (This is the reason that I need to achieve this in script itself).


      Please help me out.


      Thanks,

      Siva.