krmmkr opened a new issue, #38586: URL: https://github.com/apache/superset/issues/38586
*Please make sure you are familiar with the SIP process documented* [here](https://github.com/apache/superset/issues/5602). The SIP will be numbered by a committer upon acceptance. ## [SIP] Proposal for Adding Table Chart based on AntV S2 ### Motivation The Table and Pivot Table charts are arguably the most heavily utilized visualizations in Apache Superset. While the introduction of Table V2 (based on ag-Grid) brought significant improvements to the standard table, the Pivot Table experience still lags behind. The primary motivations for this proposal are: Licensing and Feature Paywalls: Some of the most powerful ag-Grid features (like advanced pivoting, tree data, and rich aggregations) belong to the ag-Grid Enterprise edition. This paywall severely restricts the Superset community from implementing advanced table features. Inferior Pivot Table Layout: The current Pivot Table's layout is visually dated and functionally restrictive compared to the ag-Grid-powered regular table. Missing Sorting in Pivot Tables: The existing Pivot Table implementation does not allow users to intuitively sort rows or columns by metric values. Lack of Native Rowspan: The current Table / Table V2 plugins do not natively support rowspan functionality. This makes visualizing hierarchical or grouped data visually redundant and harder for users to parse at a glance. Inaccurate Aggregations for Totals: The current Pivot Table struggles with accurate summary aggregations, specifically regarding true count distincts. For example, if an email address appears across two different dimensions, the grand total should reflect a COUNT(DISTINCT) of 1. Currently, calculating true totals and subtotals natively requires workarounds or yields inaccurate sums of sums. ### Proposed Change Introduce AntV S2 (SpreadSheet) as a new, premium alternative option for Table and Pivot Table charts. AntV S2 is an open-source, data-driven multi-dimensional analysis spreadsheet component that addresses the current limitations natively. ### New or Changed Public Interfaces Models & Endpoints: No backend changes to models, views, or REST endpoints are required. Visualizations: Introduction of a new frontend visualization plugin package (e.g., @superset-ui/plugin-chart-antv-s2). React Components: New UI components will be added to the chart control panel to expose S2-specific configurations (e.g., Grid/Tree layout modes, advanced subtotals, and canvas theme settings). CLI & Deployment: No changes or impact on the Superset CLI or deployment workflows. ### New dependencies @antv/s2: The core multi-dimensional canvas rendering engine. @antv/s2-react: The official React component wrapper for the S2 engine. Maintenance Status: Both packages are highly active, frequently updated, and backed by Ant Group. License: Both are published under the MIT License, making them fully compatible with Superset’s Apache 2.0 open-source licensing. ### Migration Plan and Compatibility The AntV S2 components will be introduced as entirely new visualization plugins (e.g., AntV Table and AntV Pivot). They will live alongside the legacy Table, Table V2 (ag-Grid), and classic Pivot Table charts without replacing them natively. Because this is an additive change, there are no immediate database migrations, script updates, or URL routing changes required. Existing dashboards and saved charts will remain completely untouched, allowing users to opt-in and transition to the S2 charts at their own pace. Organizations that have already invested in ag-Grid Enterprise licenses and integrated them into their custom Superset deployments can continue utilizing those features. The coexistence model ensures that no existing functionality or paid features are broken by this addition. ### Rejected Alternatives Describe alternative approaches that were considered and rejected. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
