Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Not able to run ARIMA forecast on multiple products, successful in running it for single

Suhas_s2092
5 - Atom

Hi Team,
We have created a ARIMA forecast which has the capabilities to model configure the best parameters for ARIMA for a single product, but we are not able to run ARIMA forecast on multiple products so need your support on how to go about this. Tried creating the batch macro but we weren't successful in that. Attaching below the working workflow for a single product. We also tried using the control parameter to input one material data at a time to the macro, but we were not very successful so would need your assistance in converting the below to be able to run across a dataset which has multiple products using a batch macro and finetune the best configurable parameters in ARIMA as we are doing it for single product or if there are any other alternatives to run it on Alteryx.
Data looks something like this which I have for 4 years, pasting a sample data below. 

 

 

 

 

Screenshot 2025-02-04 181441.png

 

Screenshot 2025-02-04 181936.png

 

2 REPLIES 2
alexnajm
18 - Pollux
18 - Pollux

Have you looked at the TS factory tools?  TS Model Factory Tool &  TS Forecast Factory Tool

Suhas_s2092
5 - Atom

Yes I did try both of them and they didn't help my case, I actually wanted the model configurations to be applied for various product groups and obtain their individual forecasts. 

Which I can currently do with a single product with the below model configurations as shown in the screenshot. Whereas when I see the configurations for TS Model factory tool and TS Forecast Factory tool, I don't exactly see the same so I would just get the forecasts using ARIMA but not the best fit model which was the case when I had the option to opt for model configurations. Attaching the screenshots of the tools you have mentioned as well for your reference. 

 

Screenshot 2025-02-04 201542.png

forecast_factory.png

 

Labels
Top Solution Authors