4 Replies Latest reply on Jul 10, 2018 2:30 PM by Richard Garcia

    5 Day Past Rolling Avg

    Richard Garcia

      I am trying to calculate past 5 Day Rolling Average but struggling to work out these details.  There are different channels within subset of data.  My goals is to create a summary by Channel past rolling 5 day average.  I tried in the Data Source tab Field Calculation with window_avg and table calculation moving avg but still struggle. 

       

       

      The result should look like for 6/13/2018 :

        

      By Channel Summary5 Day Rolling Avg.
      ab
      7.44.8

       

      Here is the sample table data:

       

      DateChannelCount
      27-Mayc5
      28-Mayc4
      28-Maye40
      29-Mayb3
      30-Maya15
      31-Mayc9
      1-Juna5
      2-Junb6
      3-Junc8
      3-June8
      4-Juna9
      5-Junb6
      6-Junb5
      6-June20
      7-Juna2
      8-Junb3
      9-Junc7
      10-Junb4
      11-Junc5
      12-Juna6