Time series extrapolation with at least one row

Options
EdBerth
EdBerth Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 15

I need to calculate the rolling average of orders by customers.

I'm working with the Time Series resampling recipe.

I have sometimes only one order for customers and in this case the extrapolation, with constant value = 0 after the order date, is not calculated.

how to have a calculated extrapolation with at least one row ?

Best Answer

  • StanG
    StanG Dataiker, Registered Posts: 52 Dataiker
    Answer ✓
    Options

    Hi,

    Series with only 1 row are ignored because interpolation on them is not possible, this is a known limitation. In our case, I'll advise you to manually create 2 extra rows for the first and last date with 0 as value for each series and select "no extrapolation" (but keep interpolation) to be sure they are all interpolated between these 2 dates only.

Answers

Setup Info
    Tags
      Help me…