FAQ | What is the difference between distinct and unique value count metrics?#
In the Column statistics section of the Metrics tab of a dataset, you’ll find options to compute a distinct value count and a unique value count.
The table below summarizes the difference between these two metrics.
Metric |
Description |
Example |
---|---|---|
Distinct value count |
The number of different values |
(A,A,B) -> 2 |
Unique value count |
The number of values appearing exactly once |
(A,A,B) -> 1 |
See also
See the reference documentation for more information on Metrics.