1. System Scope & Interactive Filters
The dashboard provides real-time and historical analytics by ingesting data from three endpoints:
getReportsSummary (room limits), getInspectionHistory (audits), and getTickets (issues).
| Filter / Feature |
Technical Behavior |
Operational Purpose |
| All-Time Cumulative View |
Evaluates all recorded audit logs and ticket states from system inception up to the end of the current calendar day (23:59:59). |
Provides standard, macro-level compliance visibility across all IT assets. |
| Cumulative Up To Date View |
Reveals the Target Date selector. Re-evaluates all historical logs and calculates room statuses, clean counts, and active tickets exactly as they existed at 23:59:59 on that date. |
Allows management to perform historical compliance retro-checks or inspect state on specific audit days. |
| Reset Button |
Resets the scope dropdown to All-Time Cumulative, hides the date picker, and re-renders full historical metrics. |
Instantly clears custom filters back to default settings. |
| Production Filter ([PROD]) |
Any ticket with a title starting with or containing [PROD] is programmatically excluded prior to calculations. |
Prevents high-level software development or production tickets from skewing IT room maintenance metrics. |
2. Station Logic, Clean Status & Progress Bar
Stations are cross-referenced dynamically between audit logs and active tickets to determine health:
┌─────────────────────────────────────────┐
│ TOTAL ROOM CAPACITY │
└────────────────────┬────────────────────┘
│
┌─────────────────────────┴─────────────────────────┐
▼ ▼
┌─────────────────────────────────┐ ┌─────────────────────────────────┐
│ INSPECTED STATIONS │ │ UNINSPECTED CAPACITY │
└────────┬────────────────┬───────┘ └─────────────────────────────────┘
│ │
▼ ▼
┌────────────────┐┌───────────────┐
│ Clean Stations ││ Active Issues │
│ (No Open Tkt) ││ (Open Tkt) │
└────────────────┘└───────────────┘
| Status Metric |
Code Variable & Rule |
Operational Meaning |
| Inspected Capacity |
dynamicRoomCounts |
Unique station IDs in a room that have at least one audit log entry recorded up to the target date. |
| Active Issues |
stationsWithOpenTickets |
Unresolved inspection tickets matching pattern [Room - StationID] open on or before target date. |
| Clean Stations |
uniqueCleanStations |
Audited stations with no active open ticket registered against them (!stationsWithOpenTickets.has(stationKey)). |
| Remaining Capacity |
grandTotalCapacity - grandTotalChecked |
Unchecked station slots remaining in the room based on total capacity limits. |
Health Track Bar Breakdown:
• Passed (Green Bar): (Clean Stations ÷ Total Capacity) × 100
• Active Issues (Red Bar): (Faulty Inspected Stations ÷ Total Capacity) × 100
• Uninspected (Grey Bar): (Remaining Capacity ÷ Total Capacity) × 100
3. Interactive Drill-Down & Manual Maintenance Table
-
Interactive Room Issues Modal: In the Audit Readiness & Room Coverage table, clicking an active issue link (e.g.,
3 Issues) triggers an interactive modal listing the exact Ticket ID, Station Title, Status, and Submission Date for that room.
-
Manual Maintenance Table: Captures general IT tasks (hardware replacements, cable re-routing, peripheral fixes) logged manually outside of standard station audit checklists. Includes real-time status badges (
Open, In Progress, Resolved).
4. SLA Compliance & Staff Takeover Logic
Active Ticket Aging Buckets:
• On Track (< 7 Days): Standard active maintenance within acceptable window.
• Warning (7–30 Days): Aging issues requiring supervisor notification.
• Action Required (> 30 Days): Critical stalled tickets exceeding operational SLAs.
Technician Performance & Takeover Attribution:
- Ticket Creation: Parsed from
Created by: [email] in notes or history logs to credit the reporting tech.
- Ticket Resolution: Credited strictly to the closing technician (
lastEditedBy or assigned resolver) when a ticket is handed over.
- Average Resolution Speed: Calculated as total elapsed resolution hours divided by resolved tickets for that technician.