Set a moving average with a 12 month period to the trendline below

gbrown · January 31

How would I overlay a moving average (12 month period) on the following trendline below:

The data is by month - 2014-present and aggregated to a monthly rollup.

Thanks,

Garrett

GrantSmith · January 31

You can use some window functions in a beast mode to do this. Specifically the LAG function. Here's a post on how to do this:

GrantSmith · January 31

You can use some window functions in a beast mode to do this. Specifically the LAG function. Here's a post on how to do this:

Best Answer