COUNTD_ AGG() performs deduplication count on the data of the specified dimension (the number of non empty cells). With the switching of user analysis dimension, the calculation field will automatically adjust dynamically with the 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.
Real-time data supports the use of a parameter of any type.
When the user's horizontal axis is the dimension field "Day", the value returned by the caculation indicator COUNTD_AGG (Sales) on the vertical axis is the number of deduplication of daily sales.
When the user's horizontal axis is the dimension field "Month", the value returned by COUNTD_AGG (Sales) is the number of deduplication of monthly sales.
For example, you use the built-in dataset "User retention data" and want to count the number of users in different regions. In this case, different phone numbers are used to represent different users. There are two implementation schemes.
Use the COUNTD_AGG function to create the calculation indicator "Number of users", and enter the formula: COUNTD_AGG (contact number), as shown in the figure below:
Drag the data into the analysis bar, as shown in the figure below:
Use dimension conversion indicators to convert "contact number" into indicator, as shown in the figure below:
COUNTD_ AGG is more often nested with other functions for conditional counting.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy