math module · Aggregation Function

math::avg

Calculate the average (mean) of numeric values across multiple rows.

Syntax

RQL

Parameters

NameTypeDescription
valueNumberThe numeric field to average

Return Value

Returns the arithmetic mean of all values in the group.

Examples

Calculate average price

$ Calculate average price
$ ctrl+enter to run

Average with total

$ Average with total
$ ctrl+enter to run
Info
This is an aggregation function. Use it with the aggregate transform to compute values across multiple rows.

Related Functions