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
Solved! Go to Solution.
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?
Thanks
Mark
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.
Hi, great thought this should work, thanks for pointing this out
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
Hi,
yes you can use a concatenation to create your group and use the TS factory tools to forecast by group.
William.
Hey there,
I tried using the tool, but I am getting the entire workflow of the macro instead of just the icon and do not know how to input the files/ data.