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)