Available aggregates - j5 - 30 - Connectors & Integration - Hexagon

j5 IP.21 Connector Configuration

ft:locale
en-US
Product
j5
Search by Category
Connectors & Integration
j5 Version
30

The following aggregates are exposed through the j5 interface:

Aggregate

IP.21 SQL function

Sum

SUM

Average

AVG

Variance

VAR

StdDev

STD

CountGood

GOOD

Maximum

MAX

Minimum

MIN

CountNotGood

NG

Range

RNG

TrendSum

Special (See Below)

The following weightings are available for these aggregates:

These correspond to the REQUEST parameter in an IP.21 Aggregate SQL query.

Weighting

IP.21 REQUEST parameter

EventWeighted

0

TimeWeighted

1

TimeWeightedExcludeStarting

2

TimeWeightedExcludeEnding

3

EventWeightedExcludeStarting

-1

EventWeightedExcludeEnding

-2