Data quality
Complete records
58%
every required field present
Fields checked
10
required fields
Impossible values
111
records to correct
Least complete field
Cancel reason
62% filled
Completeness by field
Share of records with a value
Values that cannot be right
Records failing a logic check
| Check | Records | |
|---|---|---|
| Distance below zero | 37 | Fix at source |
| Drop-off before pickup | 22 | Fix at source |
| Trip longer than 4 h | 9 | Fix at source |
| Duplicate trip ID | 14 | Fix at source |
| Space type conflicts with vehicle | 29 | Fix at source |
Completeness trend
Share of complete records
■ Complete records
Findings
- Cancel reason and attendant flag are blank most often; both are typed by hand.
- Times recorded by the phone are nearly always present.
- Negative distances come from odometer entries keyed in reverse.
Actions
- Make cancel reason a required pick-list.
- Take distance from GPS instead of odometer entries.
- Reject drop-off-before-pickup at entry.
Every name and figure on this page is invented to show the report format. RRECKTEK Transit · rreck@rrecktek.com
