Time Series Forecasting: Actual Data Shift 7 Days after Forecasting

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!

Sample.yxmd

Time Series

Accepted answers

All comments

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703