Time Series Forecasting: Actual Data Shift 7 Days after Forecasting

[dreldrel]

Hi all,

I face an issue that the actual data shifts 7 days after the TS forecast tool. For example, the data period is from 1st Jan to 31th Jan, it will change from 8th Jan to 7th Feb after forecasting. I've enclosed the sample file below, is there any way to address it?

Many thanks in advance!

[Matthew]

perhaps you can just shift it back?

DateTimeAdd( [Field1] , -7 , 'days' )

[OllieClarke]

@dreldrel My best guess here is there's a disparity between Alteryx and R counting week numbers from 0 vs from 1.

I'd log it as a bug with support

[DataNath]

Looks like it may be to do with this default date? Pulled from https://help.alteryx.com/20221/designer/ets-tool

I just added a random bunch of days and re-ran the workflow and still get exactly the same time period/forecast in the output:

[dreldrel]

Hi all,

Many thanks for all your responses, so is there any temporary solution I can use for the case at the moment?

[DataNath]

Hey @dreldrel I'm not aware of one - from the help page linked above it looks like this is just a random date that is used in the forecast display. Perhaps you could just use RecordIDs to represent the dates and the output will be in # of periods rather than a date which may be less confusing?

[dreldrel]

Hi @DataNath. thanks for your response. I'll try the method you suggested and see how it works. Many thanks again!

[DataNath]

No problem at all. Would be curious to see if there is actually a way of maintaining date ranges though, will keep an eye on this!