Returns the average of the values in a column.
Compute the average of the values in the data column AMOUNT_SOLD.
Compute the average of AMOUNT_SOLD by QUARTER_NUMBER.
average(double expr, [groupBy(...)])
- expr : expression evaluating to
groupBy: optional grouping function
doublerepresenting the average of the values in the column. If
averagereturns the average for each group.
You must include all the leading grouping dimensions in the Insight from the top-down to the level-based measure you want to evaluate. See Aggregation with Level Based Measure in Aggregating Functions.