Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

2022-05-24 Updates: Login: If you are facing issues with logging in, please try clearing all your cookies or trying another browser. We have a fix being deployed on the evening of 5/25. Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Run Time Series Forecast for multiple Brands in a single go !!!

Mahabirpanigrahi
8 - Asteroid

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.

6 REPLIES 6
MichaelLaRose
10 - Fireball

HI @Mahabirpanigrahi 

 

You can streamline your work with a batch macro.

 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/t...

 

Just batch by your brand and run the forecast in the macro. 

 

Best,

Michael

Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @Mahabirpanigrahi,

 

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

Mahabirpanigrahi
8 - Asteroid

Thank you. Do you happen to have some examples ?

Mahabirpanigrahi
8 - Asteroid

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Time-Series-Factory-Tools-vs-Batch-...

 

I found this example and it works. The way u suggested! 

 

Regards

Mahabir.

Jesus_gnzl95
5 - Atom

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 

 

 

 

sheidari
8 - Asteroid

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.

Labels