Royal Civic Teal admin experience
Operational control surface
Platform/SC02

KPI Detail

KPI 2026-07-17
Actual76.952025-12-01
Target85.4score
Attainment90.1%seed
RAGgreenCalculated by dbt
Workflow statusNo pending KPI actual workflow for this KPI.
Submit actual
JZN-KPI-0136 Improve municipal service quality KPI 136
Actual trend and threshold attainment
70.301
65.802
79.303
71.804
71.305
83.406
79.907
71.708
75.909
76.610
74.111
7712

Calculated from source actuals using configured target, polarity, and threshold bands.

actual = actual_value; target = 85.4; rag = threshold(actual, target, higher_is_better)
Unitscore
PolarityHigher is better
Refreshdaily
Source tableraw_inspections
Source fieldactual_value
Change vs prior+2.86
Classificationpublic
Source systemSRC-CRM-COMPLAINTS
Adaa readyPending
Lineageanalytics.fct_kpi_actuals
Mapped initiatives2 contributing to this KPI
Improve municipal service quality Initiative 091INIT-0091 · Owner: u_owner_09 · not_started
View progressnot_started
Milestones
62.5%
Deliverables
33.3%
Budget
72.5%
Overall77.3%
Improve municipal service quality Initiative 001INIT-0001 · Owner: u_owner_04 · in_progress
View progressin_progress
Milestones
75%
Deliverables
33.3%
Budget
58.8%
Overall75.6%
Actuals
Latest loaded periods
PeriodActualTargetRAGMode
2025-12-0176.9585.4greenseed
2025-11-0174.0985.4greenseed
2025-10-0176.6285.4greenseed
2025-09-0175.985.4greenseed
2025-08-0171.6885.4greenseed
2025-07-0179.8685.4greenseed
2025-06-0183.3885.4greenseed
2025-05-0171.3485.4greenseed