topic COVID-19 7 day rolling average serial chart in Dashboard in ArcGIS Dashboards Questions https://community.esri.com/t5/arcgis-dashboards-questions/covid-19-7-day-rolling-average-serial-chart-in/m-p/636449#M3435 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; 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?</P><P></P><P>Here is an example of the result I'd like to end up with (this is from NY Times):</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/487138_pastedImage_1.png" /></P></BODY></HTML> Wed, 01 Apr 2020 20:56:24 GMT JayJohnsonWashoeCounty 2020-04-01T20:56:24Z COVID-19 7 day rolling average serial chart in Dashboard https://community.esri.com/t5/arcgis-dashboards-questions/covid-19-7-day-rolling-average-serial-chart-in/m-p/636449#M3435 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; 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?</P><P></P><P>Here is an example of the result I'd like to end up with (this is from NY Times):</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/487138_pastedImage_1.png" /></P></BODY></HTML> Wed, 01 Apr 2020 20:56:24 GMT https://community.esri.com/t5/arcgis-dashboards-questions/covid-19-7-day-rolling-average-serial-chart-in/m-p/636449#M3435 JayJohnsonWashoeCounty 2020-04-01T20:56:24Z Re: COVID-19 7 day rolling average serial chart in Dashboard https://community.esri.com/t5/arcgis-dashboards-questions/covid-19-7-day-rolling-average-serial-chart-in/m-p/636450#M3436 <HTML><HEAD></HEAD><BODY><P>Doesn't seem like this is possible.&nbsp; So we are pre-processing the data to get the moving average.</P></BODY></HTML> Tue, 04 Aug 2020 17:07:03 GMT https://community.esri.com/t5/arcgis-dashboards-questions/covid-19-7-day-rolling-average-serial-chart-in/m-p/636450#M3436 JayJohnsonWashoeCounty 2020-08-04T17:07:03Z