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. For example we have an 6-hourly input time series with the following values.
Date/Time |
Value |
|---|---|
1-1-2007 00:00 |
1 |
1-1-2007 06:00 |
2 |
1-1-2007 12:00 |
3 |
1-1-2007 18:00 |
4 |
2-1-2007 00:00 |
5 |
If the option includeFirstValueOfAggregationPeriodInCalculation 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. In this example that would be
(1.5+2.5+3.5+4.5)/4 = 3
If the option is disabled the average wil calculated as the average of the all the instantaneous values excluding the first value (1). In this example the average would be
(2+3+4+5)/4=4.66
Configuration example
