DRAFTThis page is not published. Only visible in development mode.
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