I can think of about a dozen uniquely different ways to do this but they all involve script. I have other work to do but when I get a chance I will show you a way to do this. Here is some time series data from our pals at the
Census Bureau:
Monthly & Annual Retail Trade ~ Time Series Datahttps://www.census.gov/retail/marts/www/timeseries.html Monthly & Annual Retail Trade ~ Time Series Data ~ Grocery Storeshttps://www.census.gov/retail/marts/www/adv44510.txt I uploaded the
Grocery Store data into this application:
Moving Averagehttps://haversineconsulting.quickbase.com/db/bkks9u2da?a=td When I get a chance I will show you how you can use script and the QuickBase API to calculate
[Grocery Stores Sales 12 Month Rolling Average] from
[Grocery Stores Monthly Sales] and then generate a chart of both fields over time.
You will weep with joy at the simplicity of how to do this.
