5.4.2.3 Data types

Table 50 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 50 also outlines the data type returned for each Aggregate.

Table 50 – Standard History Aggregate Data Type information
BrowseNameValid Data TypeResult Data Type
Interpolation Aggregate
InterpolativeNumericRaw Data Type
Data Averaging Aggregates
AverageNumericDouble
TimeAverageNumericDouble
TimeAverage2NumericDouble
TotalNumericDouble
Total2NumericDouble
Data Variation Aggregates
MinimumNumericRaw data type
MaximumNumericRaw data type
MinimumActualTimeNumericRaw data type
MaximumActualTimeNumericRaw data type
RangeNumericRaw data type
Minimum2NumericRaw data type
Maximum2NumericRaw data type
MinimumActualTime2NumericRaw data type
MaximumActualTime2NumericRaw data type
Range2NumericRaw data type
Counting Aggregates
AnnotationCountAllInteger
CountAllInteger
DurationInStateZeroNumeric or BooleanDuration
DurationInStateNonZeroNumeric or BooleanDuration
NumberOfTransitionsNumeric or BooleanInteger
Time Aggregates
StartAllRaw data type
EndAllRaw data type
DeltaNumericRaw data type
StartBoundAllRaw data type
EndBoundAllRaw data type
DeltaBoundsNumericRaw data type
Data Quality Aggregates
DurationGoodAllDuration
DurationBadAllDuration
PercentGoodAllDouble
PercentBadAllDouble
WorstQualityAll StatusCode
WorstQuality2All StatusCode
Statistical Aggregates
StandardDeviationSampleNumericDouble
VarianceSampleNumericDouble
StandardDeviationPopulationNumericDouble
VariancePopulationNumericDouble