COUNT_AGG function is used to perform distinct count (not empty) for the specified dimension (dragged into the analysis area). The calculation field will make dynamic adjustment automatically when you switch the analysis dimension.
Syntax
COUNTD_AGG(Array)
Based on the current analysis dimension, this function returns the distinct count of the field. The generated results are listed in a data column. The number of rows in the data column is consistent with that in 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.
The function supports one parameter of any type for real-time data.
If the dimension field in the horizontal axis is Day, the value returned by the calculation field COUNTD_AGG(Sales Volume) is the distinct count of sales for each day.
If the dimension field in the horizontal axis is Month, the value returned by the calculation field COUNTD_AGG(Sales Volume) is the distinct count of sales for each month.
For example, if you want to count the number of customers of different contract by Contract Information, there are two implementation methods.
Method One
Create the calculation field Number of Clients with the COUNTD_AGG function. Enter COUNTD_AGG(Client ID), as shown in the following figure.
Drag the indicator into the analysis area, as shown in the following figure.
Method Two
Select Convert to Indicator to convert Customer ID from a dimension to an indicator, as shown in the following figure.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy