This example illustrates how
PivotData Microservice can be used
for building user-defined pivot table reports and charts.
-
All pivot table calculations, HTML rendering, exports are performed on the server-side
with PivotData Microservice web API.
- Builder UI (js frontend) may be embedded into any web application. This part is highly customizable.
- Live reports (direct query mode)
- Connectors: SQL Server, MySQL, PostgreSql, SQLite, DuckDB/MotherDuck, Redshift, BigQuery, ClickHouse, MongoDb, ElasticSearch, SSAS/icCube.
- Labels grouping (several dimensions) for rows/columns, expand/collapse mode
- Grand total, totals column and row, subtotals for grouped labels
- Sort by table values, totals and labels (click on rows/columns/totals label)
- Multiple values in one table, percentage/difference/running totals calculation, server-side pagination and TOP N limits, heatmap, custom formatting.
- Pivot table exports: HTML <table>, CSV, Excel, PDF, JSON, Image
- Front-end (jQuery plugins) for interactive data exploration: fixed headers, sorting, filtering, pagination, drill-down.
- PivotData Microservice (NET8 app) that can be hosted on Linux / Windows / Docker container.