You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Next »

InstantaneousToMean

Input
  • inputVariable
Options
  • allowMissingValues
  • includeFirstValueOfAggregationPeriodInCalculation
Output
  • outputVariable
Description

This transformations calculates the mean value of instantaneous values over a certain period. If the options allowMissingValues is enabled a mean value is calculated if there 1 or more valid values in the aggregation period. If the option is disabled a missing value returned if one of the values in the period is a missing value.

The transformation offers two options for calcuating the mean value over a period.  The default method (used by setting the includeFirstValueOfAggregationPeriodInCalculation option to true - this is the default behaviour) takes 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) takes the last n 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->

Alternate (like meanToMean)

 

Default

 

Alternate (like meanToMean)

Default

 

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
	<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>
  • No labels