Hello Alteryx Wizards,
Help - Run Time Series Forecast for multiple Brands in a single go !!!
My data 3 columns - Brands , period, Volume. In Brand Column, i have 12 different brands, period 36 months of data,. I want forecast next 12 months for each Brand.
Currently, I am filtering each Brand one by one and run the forecast. And Union at the end and export to excel. This is bit lengthy. As these 12 brands for 1 category, I need to run for the same for multiple categories.:(
So just checking are any way we can run the forecast for all the brands in a single go ? Any tips ?
Regards
Mahabir.
Solved! Go to Solution.
You can streamline your work with a batch macro.
Just batch by your brand and run the forecast in the macro.
Best,
Michael
Take a look at the TS Factory macros available on the Alteryx Gallery, which allow a group by function!
TS Model Factory: https://gallery.alteryx.com/#!app/TS-Model-Factory/5772af65aa690a1348cc6abf
TS Forecast Factory: https://gallery.alteryx.com/#!app/TS-Forecast-Factory/5772b060aa690a1348cc6b73
This should make your life much easier and remove a lot of your filters!
If this solves your issue please mark the answer as correct, if not let me know!
Regards,
Jonathan
Thank you. Do you happen to have some examples ?
I found this example and it works. The way u suggested!
Regards
Mahabir.
Hi, @Jonathan-Sherman , Do you know how can I compare ARIMA and ETL model using this tools? for example I have two TS Model factory one with ARIMA model and the other one with ETS model. I tried use TS compare but it doesn't work
would also love to know how you can compare the TS Model factory tool for ETS and ARIMA. The TS Compare tool doesn't seem to work with them.