Hi @diyer ,
I have a similar business case whereby the Demand prediction of Day T is dependent on the Mean & Median Demand prediction of previous time periods, e.g.:
- Day T-1
- Day T-2
- Day T-3 and so on...
So I'm unable to predict Day T+1 until I have predicted the outcome of Day T - and hence the solution similarly needs to be recursive. Is the challenge similar?
If so, one way to accommodate this recursiveness is to implement an iterative macro when performing the prediction, so that the macro:
1. Predicts Day T
2. Calculates the Mean/Median of Day T and Day T-1
3. Then, inserts this new calculation as a factor to predict Day T+1
4. And process repeats for Day T+2, Day T+3 and so on...
For more info on how to build an iterative macro, you may take a look at this tutorial video here in our Alteryx Academy: https://community.alteryx.com/t5/Videos/Build-Your-First-Iterative-Macro/td-p/55565
Do note that the predictive model itself should ideally be embedded inside the iterative macro in order to score the new data & sequential time period on a recursive basis.