How to produce multiple ARIMA forecasts from a single dataset

Question

Hello,

I am new to using Predictive Tools and I'm trying to produce distinct time series forecasts for each combination of data my (by group, by category, and by country). I'm not sure if there is a way to do this without replicating the filters for each group, category, and again for each country. With two groups, 11 countries, and as many as 92 categories, that's close to two thousand variations to set up. Is there a way to build my workflow so that it will produce these separate forecasts without setting it up so many times?

Thanks in advance!

ARIMA DB Sample.yxmd

fmvizcaino · Accepted Answer

Hey @Inactive User ,

The scaling models part of the training showcases two additional tools you can use to perform what you are looking for. These are not native tools, so you must download them from the Gallery.

https://community.alteryx.com/t5/Interactive-Lessons/Selecting-and-Scaling-Models/ta-p/610381#done

https://community.alteryx.com/t5/Community-Gallery/TS-Model-Factory/ta-p/878750

https://community.alteryx.com/t5/Community-Gallery/TS-Factory-Sample/ta-p/878594

https://community.alteryx.com/t5/Community-Gallery/TS-Forecast-Factory/ta-p/878748

Best,

Fernando Vizcaino