New metric: Duplicate (count)

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.