Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

ARIMA Model woes

aesekody
6 - Meteoroid

I am trying to do a time series forecast and my ARIMA model is running the forecast from 2007 to 2100. my data spans from 2007 to 2023. I don't know what I am doing wrong.

 

7 REPLIES 7
alexnajm
18 - Pollux
18 - Pollux

What is your ARIMA tool configuration?

aesekody
6 - Meteoroid

I used the standard configuration

aesekody_0-1680803401316.png

aesekody_1-1680803463246.png

 

 

aesekody_2-1680803510928.png

 

aesekody_3-1680803556126.png

 

 

alexnajm
18 - Pollux
18 - Pollux

It looks like you are doing options beyond the standard configuration since you are customizing the parameters in the "Model customization (optional)" part! 

 

Each line of your data is a distinct week between 2007 and 2023? Can you send a screenshot of what that looks like?

aesekody
6 - Meteoroid

aesekody_0-1680804999778.png

 

alexnajm
18 - Pollux
18 - Pollux

@aesekody can you provide a screenshot of the data, not the output?

aesekody
6 - Meteoroid

aesekody_0-1680856464366.png

The dates, and counts are random. sometimes daily, and in some cases weekly.

alexnajm
18 - Pollux
18 - Pollux

Good to know - then I would use some sort of logic to aggregate so that the data is at the weekly level. With differing levels of time, it's likely to result in odd results.

 

One possible way is to identify the Sunday for each date and use that to group by while summing the numeric field. Then your weekly breakdown should be better!

Labels
Top Solution Authors