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) takes the mean of the last n pairs, averaged 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 |
|
|
|
|
|
|
If the option alternate method is enabled, the mean value will be calculated by calculating the mean value of the first data point in the period and the second, the second data point and the third data point etc. At the end of the calculation the average value of these average values is calculated.
Configuration example
