...
Original series |
| Aggregated series |
|
|
|
|
|
---|---|---|---|---|---|---|---|
| method-> | Normal |
| Alternate |
| Normal | Alternate |
| option-> | allow missing | allow missing |
| do not allow missing | do not allow missing |
|
Date/Time | Value | Value | Calculation | Value | Calculation | Value | Value |
01-01-2007 00:00 | 1 |
|
|
|
|
|
|
01-01-2007 06:00 | 2 |
|
|
|
|
|
|
01-01-2007 12:00 | 3 |
|
|
|
|
|
|
01-01-2007 18:00 | 4 |
|
|
|
|
|
|
02-01-2007 00:00 | 5 | 3,50 | (2 + 3 + 4 + 5)/4 | 3 | (((1+2)/2) + ((2+3)/2) + ((3+4)/2) + ((4+5)/2))/4 | 3,5 | 3 |
02-01-2007 06:00 | 6 |
|
|
|
|
|
|
02-01-2007 12:00 | 7 |
|
|
|
|
|
|
02-01-2007 18:00 | NaN |
|
|
|
|
|
|
03-01-2007 00:00 | 9 | 7,33 | (6 + 7 + 9)/3 | 6 | (((5+6)/2)+((6+7)/2))/2 | - | - |
03-01-2007 06:00 | 10 |
|
|
|
|
|
|
If the option includeFirstValueOfAggregationPeriodInCalculation alternate method is enabled, the mean value will be calculated by calculating the mean value of the first data point in the period and the second, the second data point and the third data point etc. At the end of the calculation the average value of these average values is calculated. In this example that would be
(1.5+2.5+3.5+4.5)/4 = 3
If the option is disabled the average wil calculated as the average of the all the instantaneous values excluding the first value (1). In this example the average would be
(2+3+4+5)/4=4.66
Configuration example