Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

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

Time Series Forecasting

Rhitik_Krishnani
8 - Asteroid

Hello Everyone,

 

Please help me in the time series forecasting with the attached data-set

 

RETAIL STORE QTY FORECASTING

 

I want to forecast quantity sold in each month for each item name in 2022 (Jan- Dec)

and append it with my input file

 

I want to use ARIMA and ETS and forecast the value

& also compare both the models using TS Compare.

 

If possible, please don't use macro and advance logic's because I am new to Alteryx and I really need your help guys for completing the use case.

 

You can also modify the use-case to make it more better and relevant.

 

Thank You

Rhitik Krishnani

 

11 REPLIES 11
CharlieS
17 - Castor
17 - Castor

Ok, that's possible with a modification for the forecasting macro. I've updated that macro and re-attached it here. 

 

Don't forget to edit the ETS and ARIMA tools inside the macro to set the models with appropriate settings for your scenario.

 

20211207-TSCompare7.PNG

Rhitik_Krishnani
8 - Asteroid

@CharlieS 

Thank you so much for your constant support

ACCEPTED AS BEST SOLUTION

 

 

Labels