...
The transformation offers two options for calcuating the mean value over a period. One The default method (used by setting the includeFirstValueOfAggregationPeriodInCalculation option to true - this is the default behaviour) takes the mean of the last n values that fit in the output interval (includding the time itself) and stores these pairs, averages that, and stores it at the output time. The An alternate method (used similar to the MeanToMean aggregation) is enabled by setting the includeFirstValueOfAggregationPeriodInCalculation option to true – this is the default behaviour) takes the mean of false) takes the last n pairs, averages that, and stores it values that fit in the output interval (includding the time itself) and stores these 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 (like meanToMean) |
| Alternate Default |
| Normal | Alternate (like meanToMean) | Default 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 |
|
|
|
|
|
|
...