How do I rank required fields by missing-value share and count the cells to complete?
Counts refer to cells in one field. A row missing two fields contributes two missing cells.
Open Required Field MonitorTry the worked example
These are the example inputs from Required Field Monitor. Replace them in the tool to run your own case.
| Field | Expected cells | Populated cells |
|---|---|---|
| Region | 100 | 94 |
| Owner | 100 | 83 |
| Segment | 100 | 99 |
Example result
24 missing cells
Who uses this?
Data quality analyst. The free online tool runs the calculation in your browser. To edit the files and use the tools offline in one business, see the €49 offline edition.
Where the idea came from
Rank required fields by missing-value share and count the cells to complete. The demonstration requires actual execution before work can be marked complete. Benchcraft designed this tool’s inputs, decision rule and example for this office task.
Original video