I am looking to create a dynamic moving average. I understand how to create a moving average using the multi-row tool, however, I want to later change the number of days of the moving average based on the value of another field.
I am trying to optimize a prediction model and will need to run the model against a range of moving averages. in order to do so, I am planning to start with the lowest moving average value in the field called 'moving average variable' and then use an incrementing formula to increment that value by 1 up to my max moving average. I would like the moving average calculation to use the value in the field 'moving average variable' to determine the number of days to count towards the moving average.
thoughts?
form of the data-
date, value, moving average variable, moving average
thank you for the help!
