Statistics functions

The application lets you define formulas, in virtual meters, widgets or alerts. These are used to specify calculations that will be made dynamically from stored data from physical meters.

Among the functions available, some allow statistical calculations to be made over the entire selected time range.

LARGEST(expression, integer n)

Returns the nth largest value of the expression over the entire selected time range, where 1 is the index of the maximum value.

Example

LARGEST(meter, 2)
Returns the second largest value of the meter.

SMALLEST(expression, integer n)

Returns the nth smallest value of the expression over the entire selected time range, where 1 is the index of the minimum value.

Example

SMALLEST(meter, 2)
Returns the second smallest value from the meter.

CENTILE(expression, percentile)

Calculates the value corresponding to a given percentile over the entire selected time range.

Example

CENTILE(meter, 0.95)
Returns the first meter value equal to or greater than the 95ᵉ centile.

SUM_OVER_TIME(expression)

Calculates the sum of the expression over the entire selected time range.

Example

SUM_OVER_TIME(meter)
Returns the meter sum over the entire selected time range.

AVG_OVER_TIME(expression)

Calculates the average of the expression over the entire selected time range.

Example

AVG_OVER_TIME(meter)
Returns the meter average over the entire selected time range.

MAX_OVER_TIME(expression)

Calculates the maximum of the expression over the entire selected time range.

Exemple

MAX_OVER_TIME(meter)
Returns the maximum meter value over the entire selected time range.

MIN_OVER_TIME(expression)

Calculates the minimum of the expression over the entire selected time range.

Example

MIN_OVER_TIME(meter)
Returns the minimum meter value over the entire selected time range.

COUNT_OVER_TIME(expression)

Calculates the number of points in the expression over the entire selected time range.

Example

COUNT_OVER_TIME(meter)
Returns the number of meter points over the entire selected time range.

STDEV_OVER_TIME(expression)

Calculates the standard deviation of the expression over the entire selected time range.

Exemple

STDEV_OVER_TIME(meter)
Returns the meter standard deviation over the entire selected time range.