Forecasting with Jagged Range Historically
Posted: Tue Jul 26, 2016 3:25 am
Hi,
I have a model with a few series in it. The release datetime of each series doesn't line up for each month, so the set of series is "jagged". I have the release datetimes for each data series in another series. I would like to be able to forecast as of any date using a program, but don't see a way of handling it.
If I want to do a live forecast, the "Exclude for periods where actuals exist" option in the model works, but I don't know how I could apply this as of a historic date.
Thanks
I have a model with a few series in it. The release datetime of each series doesn't line up for each month, so the set of series is "jagged". I have the release datetimes for each data series in another series. I would like to be able to forecast as of any date using a program, but don't see a way of handling it.
If I want to do a live forecast, the "Exclude for periods where actuals exist" option in the model works, but I don't know how I could apply this as of a historic date.
Thanks