avg

avg — aggregate function to determine the mean average of a field or column.

SYNOPSIS

avg(expr)

DESCRIPTION

This function computes a value for each record returned by the query predicate and returns the mean average of the specified values.

The argument expr must include the name of a column in a LiveView table, where that column's data type is int, long, double, or timestamp. The returned value is of the same data type.

SEE ALSO

This LiveView aggregate function is based on the avg aggregate function in the StreamBase expression language.