Alteryx Time series for forecast

[BurcevaL]

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?

[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 · Accepted solution]

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.

[alexnajm]

@WirkKarl this is not an option with the ETS / TS Forecast tool - this is why the Factory tools are necessary

[BurcevaL]

Hi again, R tools was already downloaded, but I still cant see Factories...

Could you please advise what can be the issue? What else can be downloaded?

[alexnajm]

Did you download & install them through the pages linked above? They are a separate download, even from the Predictive R tools