I have a workflow that takes six years' worth of Social Security Payouts and I use an ARIMA model with the TS Forecast tool to predict an additional three years' worth. This data is aggregated by county, but I was only able to get the ARIMA model to work when I aggregate it by year. I would like to be able to create a forecast per county for three years. Any ideas on how to make this work? My workflow is attached.
@JenniferO the ARIMA tool looks at one dimension and one metric over time, in your case Year and Payouts. In order to do this grouping by Country field as well, you will either need to do this via batch macro, or using the TS Model Factory and TS Forecast Factory tools which are set up to do this.
Thank you for the quick reply. I did try to use the TS Factory Model after reviewing some of the documentation, prior to posting my original post, and I couldn't get it to work. I'll keep at it then.
