Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Non-equidistant time series can be transformed into equidistant time series. The function computes the equidistant values in 2 steps. First it aggregates the non-equidistant time steps to equidistant time steps, when calculating the function makes a difference between accumulated parameters and instantaneous parameters. Generally, the non-equidistant series may not fill all equidistant time steps. You can select one of the following options to fill in the gaps:

Section
Column
width15%
  • zero:
  • missing:
  • linear interpolation:
  • equal to last:
Column
width85%

the series values at intermediate time steps will be filled with zero's
the series values at intermediate time steps will be filled with missing values
the series values at intermediate time steps will be a linear interpolation between surrounding non-equidistant series observations
the series values at intermediate time steps will be equal to the last observation, (i.e. block-type filling-in).

A special option is "Average over time step". This option uses a weighted average over the values in the next time step. In the previous example, the value for 01-01-2000 05:30 is 0.0033, this is the weighted average for all time steps between 05:00 and 05:30 ((15*-0.015 + 2*0.019 + 5*0.017 + 6*0.026 + 2*0.022)/30 = 0.0033). For filling the gaps the value of the next time step is used.


...