We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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