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.

Dataiku screenshot of the column statistics section of the metrics for a dataset.

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.