...
This transformation is used to convert a non equidistant time series to an equidistant time series. The value at this time step will derived from sampling the equidistant time series. It is possible to configure how the equidistant time series should be sampled.
The available options are:
Table of Contents | ||||
---|---|---|---|---|
|
options
- maxGapLength (Only implemented for linear and block interpolation.)
- ignoreMissing / validationRule
maxGaplength: Gaps equal to or smaller than maxGapLength will be filled with sampled values. Gaps larger than maxGapLength will not be filled. If maxGapLength is not defined, then all gaps will be filled with sampled values.
ignoreMissing: if true, then missing values are ignored. If false, then an output value will be missing if one or more of the corresponding input values are missing or unreliable. Default is true.
Examples
Below examples are shown. Each example uses the same non-equidistant input timeseries, but a different sampling method is applied. The output timeseries has timesteps of 1 day.
Accumulate
Accumulates the values, weighted to the timestep, to the wanted output timestep.
TimeWeightedAverage
Calculates the average value while taking the time between different values into account account.
This is implemented as follows:
- The target time step is split over the source time steps.
- All the values of the parts of the source time steps are mutliplied by the amount of milliseconds and added together.
- The result of that addition is then divided by the amount of milliseconds of the target time step.
An example can be seen in the table below where a time series with non equidistant time step is resampled to a 15 minute time step.
Row | Time | B | Formula | Result |
---|---|---|---|---|
7 | 13-6-2021 08:45:00 | 0,015 | B7 | 0,015 |
8 | 13-6-2021 08:56:47 | 0,016 | ||
9 | 13-6-2021 09:00:00 | 0,017 | (B8 * 707000 + B9 * 193000) / 900000 | 0,016214444 |
10 | 13-6-2021 09:11:47 | 0,021 | ||
11 | 13-6-2021 09:11:53 | 0,017 | ||
12 | 13-6-2021 09:13:53 | 0,014 | ||
13 | 13-6-2021 09:13:58 | 0,016 | ||
14 | 13-6-2021 09:15:00 | 0,018 | (B10 * 707000 + B11 * 6000 + B12 * 120000 + B13 * 5000 + B14 * 62000) / 900000 | 0,019805556 |
15 | 13-6-2021 09:26:47 | 0,017 | ||
16 | 13-6-2021 09:26:48 | 0,018 | ||
17 | 13-6-2021 09:30:00 | 0,016 | (B15 * 707000 + B16 * 1000 + B17 * 192000) / 900000 | 0,0167877778 |
18 | 13-6-2021 09:41:47 | 0,015 | ||
19 | 13-6-2021 09:45:00 | 0,015 | (B18 * 707000 + B19 * 193000) / 900000 | 0,015 |
20 | 13-6-2021 10:00:00 | 0,016 | B20 | 0,016 |
21 | 13-6-2021 10:11:47 | 0,018 | ||
22 | 13-6-2021 10:11:50 | 0,017 | ||
23 | 13-6-2021 10:15:00 | 0,015 | (B21 * 707000 + B22 * 3000 + B23 * 190000) / 900000 | 0,017363333 |
Zero
Every input value that fits an output timestep is stored in the output timeseries. In this case that is only the last value, at 06-01-2014. All other values in the output timeseries are set to zero.
Missing
Every input value that fits an output timestep is stored in the output timeseries. In this case that is only the last value, at 06-01-2014. All other values in the output timeseries are set to missing.
...