| Wiki Markup |
|---|
{scrollbar} |
Instantaneous
| Excerpt |
|---|
disaggregates data by sampling the values and optionally interpolate linear |
...
Y = Y_0 + (Time_t - Time_0) * (Y_0 - Y_1)/(Time_0 - Time_1)
in which:
- Y is the interpolation result in the output series
- Y_0 is the value of the first point before Y (in the input series)
- Y_1 is the value of the first point after Y (in the input series)
- Time_t is the date/time for Y (in the output series)
- Time_0 is first time before Time_t (in the input series)
- Time_1 is first time after Time_t (in the input series)
| Input | Output (interpolation) | Output (no interpolation) |
Date/Time | Value | Value | Value |
01-01-2007 00:00 | 10,00 | 10,00 | 10,00 |
01-01-2007 06:00 |
| 8,75 | - |
01-01-2007 12:00 |
| 7,50 | - |
01-01-2007 18:00 |
| 6,25 | - |
02-01-2007 00:00 | 5,00 | 5,00 | 5,00 |
02-01-2007 06:00 |
| 6,00 | - |
02-01-2007 12:00 |
| 7,00 | - |
02-01-2007 18:00 |
| 8,00 | - |
03-01-2007 00:00 | 9,00 | 9,00 | 9,00 |
...