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 |