0 Replies Latest reply on Sep 5, 2012 8:20 AM by Dylan Spencer

    Last 7 and last 30 day running average

    Dylan Spencer

      I'd like to create a table similar to the table below. I'd like the user to be able to utilize date filters and not impact the rolling averages. I tried using basic table calculations but this doesn't really use the last 7 days, just the previous 7 values. Any ideas as to how I would accomplish this?

       

       

      DateMetricAvg (last 7 days)Avg (last 30 days)
      1/2/201210129
      1/3/2012151412
      1/4/2012121410
      1/5/2012242118