...
The transformation offers two different ways for calculating the mean value over a period. The default method (used by setting the includeFirstValueOfAggregationPeriodInCalculation option to true - this is the default behaviour) calculates the mean of the last n pairs, averages that, and stores it at the output time. An alternate method (similar to the MeanToMean aggregation) is enabled by setting the includeFirstValueOfAggregationPeriodInCalculation option to false) calculates the mean of all values that fit in the output interval, excluding the start time itself, and stores that at the output time.
In the table four tables below an example examples of in and output using both methods is given:
the different options are given.
Example for includeFirstValueOfAggregationPeriodInCalculation is true and allowMissingValues is false:
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 | (((5+6)/2)+((6+7)/2))/2 | 6 |
2007-01-03 06:00 | 10 |
|
|
Example for includeFirstValueOfAggregationPeriodInCalculation is true and allowMissingValues is true:
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 | ||||||||
includeFirstValueOfAggregationPeriodInCalculation: |
|
| false |
| true |
| false | true | |
allowMissingValues: |
|
| false |
| false |
| true | true | |
| Date/Time | Input Value | Output 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 | |
2007 |
| 02-01-2007 02 06:00 | 6 |
|
| ||||
2007-01-02 12:00 | 7 |
|
| ||||||
2007-01-02 18:00 | NaN |
|
| ||||||
02 2007-01-2007 1203 00:00 | 9 | NaN | |||||||
2007-01-03 06:00 | 7 10 |
|
|
Example for includeFirstValueOfAggregationPeriodInCalculation is false and allowMissingValues is false:
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 |
|
| ||||||
02 2007-01-2007 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 | NaN |
|
|
|
|
|
|
|
03 2007-01-2007 03 00:00 | 9 | 7,33 | (6 + 7 + 9)/3 | 7,33 | |||||
2007-01-03 06:00 | 10 |
|
|
Example for includeFirstValueOfAggregationPeriodInCalculation is false and allowMissingValues is true:
2007-01-01 00:00 | 1 |
|
| |||||||
2007-01-01 06:00 | 2 |
|
| |||||||
2007-01-01 12:00 | 3 | 6 | (((5+6)/2)+((6+7)/2))/2 | NaN | NaN |
|
| |||
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 |
| 03-01-2007 06:00 | 10 |
|
|
|
|
|
|
Configuration example
| No Format |
|---|
<transformation id="aggregation instantaneousToMean"> <aggregation> <instantaneousToMean> <inputVariable> <timeSeriesSet> <moduleInstanceId>ImportTelemetry</moduleInstanceId> <valueType>scalar</valueType> <parameterId>H.obs</parameterId> <locationSetId>hydgauges</locationSetId> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="minute" multiplier="15"/> <relativeViewPeriod unit="day" startOverrulable="true" start="-7" end="0"/> <readWriteMode>read only</readWriteMode> <delay unit="minute" multiplier="0"/> </timeSeriesSet> </inputVariable> <allowMissingValues>true</allowMissingValues> <outputVariable> <timeSeriesSet> <moduleInstanceId>Aggregate_Historic</moduleInstanceId> <valueType>scalar</valueType> <parameterId>instantaneousToMean</parameterId> <locationSetId>hydgauges</locationSetId> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="hour" multiplier="1"/> <relativeViewPeriod unit="day" startOverrulable="true" start="-7" end="0"/> <readWriteMode>add originals</readWriteMode> <synchLevel>1</synchLevel> </timeSeriesSet> </outputVariable> </instantaneousToMean> </aggregation> </transformation> |