...
The transformation offers two options for calcuating the mean value over a period. One method (the default) takes the last n values that fit in the output interval (includding the time itself) and stores these at the output time. The alternate method (used by setting the includeFirstValueOfAggregationPeriodInCalculation option to true) takes the mean of the last n pairs, averaged averages that, and stores it at the output time.
In the table below an example of in and output using both methods is given:
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 |
|
|
|
|
|
|
...
Configuration example