Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

ETS & ARIMA Tool Error: Error in round(fit.stat,7) + no valid fields were selected

sheidari
8 - Asteroid

I'm getting the following errors when running an ETS and ARIMA workflow and not sure why as it's run fine in the past. Any help would be greatly appreciated!

 

sheidari_2-1639002655606.png

 

 

3 REPLIES 3
TheOC
15 - Aurora
15 - Aurora

Hey @sheidari 

Your zipped file is missing a macro by the seems, please can you reattach with the macro packaged?

TheOC_0-1639004157961.png



Cheers,
TheOC


Bulien
sheidari
8 - Asteroid

How about now, @TheOC ?

TheOC
15 - Aurora
15 - Aurora

hey @sheidari 

You have a large number of nulls in the dataset:

TheOC_0-1639042565986.png

 


you might want to remove these, i've done that first:

TheOC_1-1639043098434.png



The next thing i noticed is that your timeseries tools dont have a target field selected:

TheOC_2-1639043731928.png

and because none of your fields are numeric - it wont let me select one. I fixed that by setting sales as a double in your select:

TheOC_3-1639043879664.png



then it seems to work fine:

TheOC_4-1639043918528.png



Hopefully this helps, workflow is attached.

TheOC


Bulien
Labels