added
New metric: Duplicate (count)
4 months ago
Duplicate (count)
is now available within Metric monitors. This metric is a useful alternative to the Unique (%)
metric, particularly if you are looking to ensure a column is always 100% unique. On large tables, a small number of duplicates can cause 100% unique to become 99.99999% unique. Which can be hard to visualize in charts and can sometimes be rounded off.
Duplicate (count)
is a much easier way to visualize uniqueness. Since if a duplicate emerges, it goes from 0 to 1 instead of 100% to 99.99999% unique.
Duplicate (count)
is calculated as the difference between the total number of rows with non-null values and total number of distinct non-null values.
Check out our full list of available metrics.
![](https://files.readme.io/0a12c62-Pasted_Image_5_1_24__3_20_PM.png)