Returns the average value of a set of numbers.

The AVG function calculates the average value of a numeric field.

In this article:




  • value - 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:

AVG Examples

In these examples, the parameters passed to AVG are unaggregated numeric dimensions (i.e., they have an Aggregation type of None).

AVG(CASE WHEN My Dimension < 1 THEN .5
WHEN My Dimension >= 1 AND My Dimension < 5 THEN 1
Was this helpful?
How can we improve it?