Views Created - 30 Day Moving Average

[duncan]

Hello @James4Quicksight

I would recommend checking out the solution below for another moving average question. This has fairly good detail of the problem and a link to demo central:

Moving average

Hello, I have a dataset with fields id, bill_date, company along with other fields. I need to calculate 7-day and 30-day moving average of the count of records for each bill_date and break it down by company. I have a table visual, with company as rows, bill_date as columns. I need to show three values: total count of records, 7-day moving average and 30-day moving average for each day. There are filters for bill_date and company, so user can filter the data as needed. I am using below calcula…

For your KPI, are you looking for the 30 day average of a metric or do you want a metric that shows the daily average?