Worked example: completeness of product records
The catalog has 5,000 product records and four mandatory fields are checked. The fill rates are illustrative.
Figures
- Category
- 4,900 of 5,000: 98%
- Size
- 4,650: 93%
- Barcode
- 4,400: 88%
- Cost
- 4,000: 80%
- Overall completeness (calculation)
- 17,950 / 20,000 ≈ 89.8%
Lesson
The average hides the weak field: cost is filled for 80%, so margin cannot be calculated for every fifth record. Assign an owner to each field and check completeness when a record is created.