Alteryx Time series for forecast

Hi, I havent used time series previously and when I am trying to use ETS tool and TS forecast tool, I don't get the output I want to see.
I have attached simulated data below, 2 different products and several location they might be produced at and sold volumes for each month.When I do it in workflow, I get summary per each month for all products and locations.

How can I make it forecast 12 months further by product and location combination?

Simulation.xlsx

Time Series

Accepted answers

alexnajm

As mentioned, they must be downloaded! It also says this on the tool's respective pages 😊

alexnajm

If you have not gone through the Community to find them, here they are: TS Model Factory - Alteryx Community & TS Forecast Factory - Alteryx Community. If you are still seeing issue after this, please contact Alteryx Support or detail exactly what you have done to download and install these tools

All comments

alexnajm

That's correct - the Time Series tools will default to treating all your data as part of the same group. You can use the time Series Factory tools if you want to product models per group - there are tools to download ( TS Forecast Factory Tool & TS Model Factory Tool) or you can build a batch macro: Time Series Factory Tools vs Batch Macro Time Series

BurcevaL

Thank you, now its clear.

Please advise, how can I build the macro into the alteryx? (As I dont have a full user).

alexnajm

If you can use the ETS Tool, then you should have Full User access... ETS Tool is Full User only

BurcevaL

I dont know than, because I have no factory tools if I search.

alexnajm

As mentioned, they must be downloaded! It also says this on the tool's respective pages 😊

WirkKarl

Hi! It sounds like your workflow is aggregating across all products and locations. You’ll want to make sure you use the ‘Group By’ option in the ETS/TS Forecast tool to separate each Product + Location combination. That way, the forecast will run individually for each group and you can extend it 12 months into the future.