Overview
Syntax | AVG_AGG(Array) | Returns the summary average value of the indicator field based on the current analysis dimension. The result generated is a data column with the same number of rows as that of the current analysis dimension. |
Parameter | Array | The Array parameter must be the result returned by a non-aggregate function formula, which can be a calculation result of an indicator field, dimension or indicator field and a common formula. |
Notes
The function supports one numeric parameter for the real-time data.
Example
If the horizontal axis is the dimension field Day, the value returned by the calculation field AVG_AGG(Sales Volume) of the vertical axis is the average daily sales.
If the horizontal axis is the dimension field Month, the value returned by AVG_AGG (Sales Volume) is the average monthly sales.
For example, you can calculate the average contract amount per year in Contract Information by two implementation methods.
Method One: Using the AVG_AGG Function
Create a Calculation Field named Average Contract Amount, enter AVG_AGG(Contract Amount), and drag the field into the analysis area, as shown in the following figure.
Method 2: Calculating the Average Value by Summary Mode
Drag Contract Amount into the Indicator bar, choose Summary Mode > Average in the drop-down list of Contract Amount, as shown in the following figure.
For details, see Summary Modes for Tables.
Previous：VAR_AGG - Variance
