Timeseries Arima - only giving me mean values for forecast. Please help!

[brad567]

Hi all,

I'm new to Alteryx and i'm trying to do timeseries arima.

When i input my test data and forecast for next 5 days of values, it only gives me the mean of my input as forecast result.

Can someone please help? Please see attached alteryx file.

Any help is highly appreciated. :)

[mceleavey · Accepted solution]

Hi @brad567 ,

I think this might be to do with the fact that there are only ten rows running into the model, over a very short time period.

It's unlikely that the model can find any signal do deviate from the mean in such a small dataset.

If you had maybe two years of data then you are likely to see more variations.

M.

[brad567]

Got it.

It worked now when i loaded last 120 days of value in my model.

Thank you very much :)

[mceleavey]

No problem.

Glad I could help.

M.