Alteryx designer Discussions

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

ARIMA and ETS Prediction

Highlighted
7 - Meteor

Hi,

 

I just a quick question about the Predictive tools within Alteryx. I was wondering if it is possible, if you already have existing time series data, to allow Alteryx to predict beyond the data that is already in place. I've seen situations where users have given Alteryx specific data to allow it to predict from scratch what the outcome will be using either the ARIMA or ETS method, but nothing about doing what I suggested. It seems like it should be possible going from the ETS or ARIMA tool into the TS Plot tool, but so far I haven't successfully been able to make that happen.

 

Any help would be much appreciated.

 

Thanks,

Justin

Highlighted
ACE Emeritus
ACE Emeritus

Hi @jmarleigh

I believe you'll need to use a TS Forecast tool to make the future predictions.  I can't see any other way.

 

Highlighted
7 - Meteor

@JohnJPS - I just got there in regards to feeding ARIMA into the TS Forecast tool. One more question, is it possible to forecast for multiple items in a single workflow?

Highlighted
ACE Emeritus
ACE Emeritus

Hi @jmarleigh

The easy way would be to run from one source into multiple ARIMA tools, and set each to forecast a different target field. If you wanted one tool to generate forecasts for multiple fields, you would have to write an iterative macro, which I'm guessing is certainly possible, but might get a bit involved.

Highlighted
Alteryx Alumni (Retired)

Hi @jmarleigh,

 

Actually, there are macros on the Predictive District of the Gallery that solve the problem of performing multiple predictions. The TS Model Factory macro creates models for multiple items at once, and the TS Forecast Factory macro estimates forecasts for these models. If you want more customization than these macros allow, @JohnJPS's approach will work. However, the R tool takes about 2 seconds to initialize every time, so putting an R tool in an iterative macro can create some performance concerns.

 

Bridget Toomey

Research Scientist, Analytic Products

Alteryx
Highlighted
5 - Atom

Hi BridgeT,

 

I am using the TS Model Factory and TS Forecast Factory for co-variate Arima forecasting. The models worked well in the past, but recently I have been receiving this error in the TS Forecast Factory: 

 

Error: TS Forecast Factory (92): Tool #20: Error in forecast.Arima(mod.obj, h = nrow(covars), xreg = covars, level = conf.ints) :
Error: TS Forecast Factory (92): Tool #20: Execution halted
Error: TS Forecast Factory (92): Tool #20: The R.exe exit code (1) indicated an error.

 

Will you be able to shed any light on what they mean and how I can go about fixing it? Any help will be appreciated.

 

Thanks!

Highlighted
5 - Atom

Hi,

 

I am getting same error, just wondering, have you got the solution for this yet?

 

thanks,

Farhad

 

Labels