Apache Superset 6.1.0: Executive KPI Comparison & Variance Card
Custom Big-Number and Executive KPI scorecard plugin for Apache Superset 6.1.0 (`superset-plugin-chart-kpi-comparison` and `superset-plugin-chart-kpi-card`). Engineered for healthcare direction dashboards to compare current period metrics against regional targets, prior-year baselines, and budget ceilings with polarity-aware semantic coloring.
Executive Healthcare Scorecard Engineering
In hospital executive dashboards, a positive percentage change is favorable for surgical throughput, but unfavorable for Emergency Department wait times or readmission rates. Native Big Number charts lack multi-baseline comparison and metric polarity semantics.
Scorecard Capability Matrix
| Scorecard Feature | Native Big Number with Trendline | KPI Comparison & Card Plugin | Executive Dashboard Value |
|---|---|---|---|
| Baseline Comparisons | Single prior point | Simultaneous Target + YoY + Budget deltas | Complete executive context in 1 card |
| Metric Polarity | Fixed green up / red down | Configurable (`Higher is Better` vs `Lower is Better`) | Accurate clinical SLA status coloring |
| Sparkline Overlay | Basic area line | Min/Max band + target threshold line | Instant trend trajectory assessment |
| Conditional Formatting | Manual CSS overrides | Rule-based traffic-light status tokens | Zero-code governance for BI analysts |
*Table 1: Executive KPI Comparison Plugin vs Native Big Number*
Key Capabilities
- Polarity-Aware Variance Engine: Automatically inverts green/amber/red status tokens for metrics where reduction is the clinical goal (e.g., waiting lists, length of stay). - Compact Multi-KPI Grid: Responsive typography and SVG sparklines engineered for dense executive wallboards.