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. 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 – this is the default behaviour) takes the mean of the last n pairs, 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