Apache Superset 6.1.0 — Hierarchical Table & Matrix Grid Plugin
Production-grade visualization plugin for Apache Superset 6.1.0 built with React, TypeScript, and Ant Design v5, accompanied by a companion Python backend calculation engine. Engineered to solve enterprise hierarchical reporting challenges, supporting dynamic multi-dimension tree grouping, parent-child recursion via SQL CTEs, in-tree path-preserving search, sticky headers/columns, roll-up subtotals, and bidirectional dashboard cross-filtering (setDataMask).
Enterprise BI & Hierarchical Data Complexity
Standard visualization matrices in Business Intelligence tools struggle when displaying uneven organizational hierarchies, financial statements (P&L balance sheets), and multi-tier categorical rollups.
Monorepo Architecture & Capability Matrix
The plugin monorepo integrates a high-performance React tree grid with companion Python aggregation engines:
| Feature / Dimension | Native Superset Pivot Table | Hierarchical Table Plugin (v6.1.0) | Enterprise Value |
|---|---|---|---|
| Hierarchy Depth | Fixed column pivoting | Unlimited dynamic depth / recursion | Supports uneven corporate structures |
| Intermediate Subtotals | Top or bottom only | Inline collapsible subtotal rows | True financial P&L layout |
| Cross-Filter Engine | Row click single dimension | Multi-level node setDataMask | Synchronizes sibling charts instantly |
| In-Tree Search | Not supported | Real-time path-preserving filter | Instant search in 10,000+ rows |
*Table 1: Native Pivot Table vs Hierarchical Table Plugin*
// Dynamic tree aggregation and cross-filter emission in TypeScript
import { HierarchicalTableChartPlugin } from 'superset-plugin-chart-hierarchical-table';export function emitTreeCrossFilter(nodeId: string, dimensionKey: string, setDataMask: (mask: any) => void) { setDataMask({ extraFormData: { filters: [ { col: dimensionKey, op: 'IN', val: [nodeId], }, ], }, filterState: { value: [nodeId] }, }); } `
Key Architectural Capabilities
- Hierarchy Modes: Toggle between *Multi-Dimension Grouping* (Country > Region > Store) and *Parent-Child Adjacency* (
node_id/parent_id). - Interactive In-Tree Search: Real-time filtering preserving root-to-leaf branch lineage with search term highlight.
- Rollup & Aggregations: Automatic computation of intermediate subtotal rows and top-level Grand Total summary.
- Sticky Freeze Panes: Independent vertical lock for column headers and horizontal lock for hierarchical dimension columns.