...
Date/Time | Value |
---|---|
1-1-2007 00:00 | 1 |
1-1-2007 06:00 | 2 |
1-1-2007 12:00 | 3 |
1-1-2007 18:00 | 4 |
2-1-2007 00:00 | 5 |
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 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
...