COVID-19 7 day rolling average serial chart in Dashboard

752
1
Jump to solution
04-01-2020 01:56 PM
JayJohnsonWashoeCounty
Regular Contributor

I'd like to create a serial chart in Dashboard that shows a rolling average - showing the average change in the total COVID-19 cases over the past 7 days.  Is there any way to do this from a simple table of cases, where each row in the table contains the date and a case count?

Here is an example of the result I'd like to end up with (this is from NY Times):

Jay
Washoe County GIS
1 Solution

Accepted Solutions
JayJohnsonWashoeCounty
Regular Contributor

Doesn't seem like this is possible.  So we are pre-processing the data to get the moving average.

Jay
Washoe County GIS

View solution in original post

0 Kudos
1 Reply
JayJohnsonWashoeCounty
Regular Contributor

Doesn't seem like this is possible.  So we are pre-processing the data to get the moving average.

Jay
Washoe County GIS

View solution in original post

0 Kudos