<< Click to Display Table of Contents >> Distinct Count |
![]() ![]() ![]() |
Distinct values are counted. When the data volume is small, it is similar to the accurate distinct value count, that is, the number of rows with different data values in all data is calculated. Only when the amount of large data is different, the different value counts may differ from the results of the exact different values. That is, when the data volume is large, the exact different value data is still the data amount of all the different values in all the data, and the different value counts only The number of data of different values is calculated from the partial data.
For example, bind 2 columns of "MARKET" and "SALES" to the table component. The aggregation method of the column "SALES" is a distinct count. As shown in the figure below, the value of different values of SALES data corresponding to Central is 330, and the accuracy is different. The value count has a value of 322.