community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Forecasting using multiple groupings (ARIMA)

Meteor

HI, I am using the TS Forecast (ARIMA) to forecast sales units, for customer/product for the next 12 months, I have installed the TS Forecast Model Factory, but cant figure out how to do this? any help would be much appreciated

 

Thanks

Mark

Alteryx
Alteryx

Hi,

can you have a look at this link ?

Regards 

Meteor

Hi @WilliamR, I did go though this, with the tool it only allows for one grouping field and target, with my analysis I am forecasting for sales by 2 grouping fields customer(s) and product(s), thoughts?

 

TS Model Factory.PNG

 

Thanks

Mark

Alteryx
Alteryx

Hi,

if you want to forecats by group customer/product, you should concatenate those variables in one with a formula tool no? So your model would take one field for the grouping field and you will have one forecat per customer/product.

Meteor

Hi, great thought this should work, thanks for pointing this out

Meteoroid

Hi William, 

 

Could I use 4 dimensions/groups for forecasting;

Will the same methodology of concatenation work?

Should this be done using TS Model Factory tool?

 

Forecast Sales by below grouping :

 

Product/Year/Segment/Customer Type

Alteryx
Alteryx

Hi,

yes you can use a concatenation to create your group and use the TS factory tools to forecast by group.

William.

Labels