According to the current analysis dimension, the summary average value of the indicator field is returned, and the generated result is a data column with the number of rows consistent with the current analysis dimension.
It 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.
The real-time data supports the use of a single numeric type parameter.
When the user's horizontal axis is the dimension field "Day", the value returned by the calculated field AVG_AGG (Sales) on the vertical axis is the average daily sales;
When the user's horizontal axis is the dimension field "Month", the value returned by AVG_AGG(Sales) is the average monthly sales.
For example, using the built-in dataset "Contract fact sheet" to calculate the annual average contract amount, there are two calculation methods.
Create the calculation indicator "Average contract amount" and enter the formula: AVG_AGG (Contract amount). And drag it into the analysis bar, as shown in the figure below:
Drag "Contract amount" into the indicator column, and click "Dropdown>Summary mode>Average", as shown in the figure below:
For details, please refer to: Averaging by Aggregation Method.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy