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):
Solved! Go to Solution.
Doesn't seem like this is possible. So we are pre-processing the data to get the moving average.
Doesn't seem like this is possible. So we are pre-processing the data to get the moving average.