AVG function calculates the average value of a numeric field.
value- a field or expression that evaluates to an unaggregated number.
How the AVG function works
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
- in a report, edit the field's aggregation in a chart.
In these examples, the parameters passed to AVG are unaggregated numeric dimensions (i.e., they have an Aggregation type of
AVG(CASE WHEN My Dimension < 1 THEN .5
WHEN My Dimension >= 1 AND My Dimension < 5 THEN 1