ETS Time series

[goutamgm92]

Hi,

I am using an ETS forecast container followed by a TS Forecast container connected to the O part of the previous ETS.

My dataset contains data from 2010 month 1 to 2017 to month 9, I am doing a monthly prediction, but the ETS forecast begins the forecast output from 2015 year month 11 instead of 2017 month 10, it always ignores the last 21 records in the input dataset. I tried removing and adding few rows and saw that it always neglects the last 21 rows. How do I fix it>

[HossC]

Hello @goutamgm92, 

I'm having trouble reproducing this. Is there any chance you can share your workflow?  Options => Export Workflow

Thanks!

Hoss Carroll

Customer Support Engineer

Alteryx

[goutamgm92]

Attached the exported workflow, here I am trying to forecast the domestic value and I have monthly data till year 2017 and month 7, but the forecast starts at year 15 and month 11, but I think it should be 2017 and month 8

[HossC · Accepted solution]

Hey @goutamgm92,

I think I've got it figured out! While the forecast is correct, the Period and Sub_Period fields are returning the wrong values because the Series starting period is not set. After setting this value to 2002 and 10, the first period that is forecast becomes 2017 month 8. The updated workflow has been attached.

Set series starting period

Let me know if this does not resolve your issue!

Hoss Carroll

Customer Support Engineer

Alteryx

[HabeebAlAli]

Helfull, Thank you

it resolved my issue with Period and Sub_Period being random to exactly what it should be