Royal Civic Teal admin experience
Operational control surface
?
...
unknown
Model catalogue
/
Admin / dbt Studio / Models
mart_executive_summary
Open in Studio
SJ
Stale
last run 2025-07-01 02:00
· 312 rows
Compile
Test
Run
SQL
Compiled
Lineage
Docs
Preview
models/gold/mart_executive_summary.sql
Copy
{{ config(materialized='table', schema='gold') }} select d.district_name, d.region, s.period, count(distinct s.kpi_code) as kpi_count, avg(s.attainment_pct) as avg_attainment, sum(case when s.kpi_status='meeting' then 1 end) as meeting, sum(case when s.kpi_status='breach' then 1 end) as breach_count from {{ ref('kpi_cascade_snapshot') }} s join {{ ref('dim_district') }} d using(district_id) group by 1,2,3
Console
Clear
-- mart_executive_summary · open in dbt Studio