Table 13 outlines the valid DataType for each Aggregate. Some Aggregates are intended for numeric data types – i.e. integers or real/floating point numbers. Dates, strings, arrays, etc. are not supported. Other Aggregates are intended for digital data types – i.e. Boolean or enumerations. In addition some Aggregates may return results with a different DataType than those used to calculate the Aggregate. Table 13 also outlines the data type returned for each Aggregate.
Table 13 – Standard History Aggregate Data Type information
|
BrowseName |
Valid Data Type |
|
|
|
Interpolation Aggregate |
|
|
Interpolative |
Numeric |
Raw Data Type |
|
|
Data Averaging Aggregates |
|
|
Average |
Numeric |
Double |
|
TimeAverage |
Numeric |
Double |
|
TimeAverage2 |
Numeric |
Double |
|
Total |
Numeric |
Double |
|
Total2 |
Numeric |
Double |
|
|
Data Variation Aggregates |
|
|
Minimum |
Numeric |
Raw data type |
|
Maximum |
Numeric |
Raw data type |
|
MinimumActualTime |
Numeric |
Raw data type |
|
MaximumActualTime |
Numeric |
Raw data type |
|
Range |
Numeric |
Raw data type |
|
Minimum2 |
Numeric |
Raw data type |
|
Maximum2 |
Numeric |
Raw data type |
|
MinimumActualTime2 |
Numeric |
Raw data type |
|
MaximumActualTime2 |
Numeric |
Raw data type |
|
Range2 |
Numeric |
Raw data type |
|
|
Counting Aggregates |
|
|
AnnotationCount |
All |
Integer |
|
Count |
All |
Integer |
|
DurationInStateZero |
Numeric or Boolean |
Duration |
|
DurationInStateNonZero |
Numeric or Boolean |
Duration |
|
NumberOfTransitions |
Numeric or Boolean |
Integer |
|
|
Time Aggregates |
|
|
Start |
All |
Raw data type |
|
End |
All |
Raw data type |
|
Delta |
Numeric |
Raw data type |
|
StartBound |
All |
Raw data type |
|
EndBound |
All |
Raw data type |
|
DeltaBounds |
Numeric |
Raw data type |
|
|
Data Quality Aggregates |
|
|
DurationGood |
All |
Duration |
|
DurationBad |
All |
Duration |
|
PercentGood |
All |
Double |
|
PercentBad |
All |
Double |
|
WorstQuality |
All |
|
|
WorstQuality2 |
All |
|
|
|
Statistical Aggregates |
|
|
StandardDeviationSample |
Numeric |
Double |
|
VarianceSample |
Numeric |
Double |
|
StandardDeviationPopulation |
Numeric |
Double |
|
VariancePopulation |
Numeric |
Double |