| scrollbar |
|---|
| Excerpt | ||
|---|---|---|
| ||
aggregates data by calculating the mean value |
MeanToMean
Input
- InputVariable
Output
- OutputVariable
Description
This transformation performs an aggregration from an a mean input time series to a mean output time series. The average value of the mean value in the aggregation period (excluding the value at the start of the period) will be the calculated mean value for the output time series.
| Original series | Result |
|---|---|---|
Date/Time | Value | Value |
01-01-2007 00:00 | 1,00 |
|
01-01-2007 06:00 | 2,00 |
|
01-01-2007 12:00 | 3,00 |
|
01-01-2007 18:00 | 4,00 |
|
02-01-2007 00:00 | 5,00 | 3,50 |
02-01-2007 06:00 | 6,00 |
|
02-01-2007 12:00 | 7,00 |
|
02-01-2007 18:00 | 8,00 |
|
03-01-2007 00:00 | 9,00 | 7,50 |
03-01-2007 06:00 | 10,00 |
|
This method will give the same results as the instantaneoustoMean transformation transformation while setting the includeFirstValueOfAggregationPeriodInCalculation option to false. However, before 2016.02 it has no option to ignore missing values in the input series. This has been implemented in 2016.02 build 62835.
...