COUNTD_AGG

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.

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.

3.1 Method one

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:

3.2 Method two

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.