KPI Dashboard

Completed, Closed, Not Done, and Missed operational states
Companies
23
Completed Flag
666
Incomplete Flag
137
Missed Flag
679
Completion Rate
44.9%

Monthly Status Trend

Closing contributes to Completed Flag; dash is Not Done; blank is Missed.
CompletedClosedNot DoneMissed

Status Distribution

Every record is assigned exactly one operational state.

Completion by Service

Completed Flag divided by all records, including Not Done and Missed.

Recommended Use of Basis

Basis should be a filter and workload context, not a headline KPI.
Keep Monthly, Quarterly, and 1/2 Yearly.

Because blanks now count as Missed, future months may reduce completion rates. Use the Month filter to evaluate only the reporting period currently due, and compare performance within the same Basis.
Showing the prepared snapshot. Upload a refreshed cleaned Excel workbook to update every visual instantly.