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

Result 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

StatusCode

WorstQuality2

All

StatusCode

Statistical Aggregates

StandardDeviationSample

Numeric

Double

VarianceSample

Numeric

Double

StandardDeviationPopulation

Numeric

Double

VariancePopulation

Numeric

Double