The AVG
function calculates the average value of a numeric field.
Syntax
Parameters
X
- a field or expression that evaluates to an unaggregated number.
How the AVG
function works
The AVG
function takes 1 parameter, which must be the name of a numeric field, or a numeric expression. AVG
returns the average for all values of that field or expression.
You can't apply this function to a pre-aggregated field (Aggregation equals Auto
), or to an expression which is the result of another aggregation function. For example, a formula such as AVG(SUM(x))
will produce an error.
There are 2 other ways to apply this function:
- In a data source, change a field's Aggregation to
Average
. - in a report, edit the field's aggregation in a chart.
Examples
In these examples, the parameters passed to AVG
are unaggregated numeric dimensions (i.e., they have an Aggregation type of None).
Example formula | Input | Output |
---|---|---|
AVG(Latency) |
|
0.06 |
AVG(CASE WHEN My Dimension < 1 THEN .5 WHEN My Dimension >= 1 AND My Dimension < 5 THEN 1 ELSE 2 END) |
|
1 |