...
Date/Time | Input Value | Calculation | Output Value |
---|---|---|---|
2007-01-01 00:00 | 1 |
|
|
2007-01-01 06:00 | 2 |
|
|
2007-01-01 12:00 | 3 |
|
|
2007-01-01 18:00 | 4 |
|
|
2007-01-02 00:00 | 5 | (((1+2)/2) + ((2+3)/2) + ((3+4)/2) + ((4+5)/2))/4 | 3 |
2007-01-02 06:00 | 6 |
|
|
2007-01-02 12:00 | 7 |
|
|
2007-01-02 18:00 | NaN |
|
|
2007-01-03 00:00 | 9 | - | NaN |
2007-01-03 06:00 | 10 |
|
|
Example for includeFirstValueOfAggregationPeriodInCalculation = false and allowMissingValues = false:
...
2007-01-01 00:00 | 1 |
|
|
2007-01-01 06:00 | 2 |
|
|
2007-01-01 12:00 | 3 |
|
|
2007-01-01 18:00 | 4 |
|
|
2007-01-02 00:00 | 5 | (2 + 3 + 4 + 5)/4 | 3,50 |
2007-01-02 06:00 | 6 |
|
|
2007-01-02 12:00 | 7 |
|
|
2007-01-02 18:00 | NaN |
|
|
2007-01-03 00:00 | 9 | - | NaN |
2007-01-03 06:00 | 10 |
|
|
Configuration example
...