glideapps / glideapps/expert-issues

Native Pivot Table Component for Aggregated Reporting

Open
#70 0 comments 2 reactions 0 assignees View on GitHub
Dominant language
No language data
Stars
5
Forks
0
PR merge metrics
No merged PRs in 30d

Description

**Summary**
Following the release of the new Chart components, users now need a **Pivot Table** (or "Summary Table") component. While Charts are excellent for visualization, business users often require the exact aggregated numbers in a tabular format for reports. We need a component that uses the same aggregation logic as the Charts (grouping by Category/Date) but displays the output as a structured grid of numbers (Sums, Counts, Averages) rather than a visual graph.

**Current Problem**
* **Visual vs. Exact Data:** The new Charts are great for trends, but they are not suitable for detailed reporting. Users cannot easily read the exact value of a specific bar or export the summarized data.
* **Raw Data vs. Summary:** The standard Table component lists *every single row* (e.g., 1,000 transactions). Users need to see a *summary* (e.g., 5 rows representing Total Sales per Month).
* **Complex Workarounds:** Currently, to build a simple summary report (e.g., "Sales by Manager"), developers must create separate "Helper Tables," use complex Query columns, and Rollups in the backend. This is inefficient when the data engine clearly already knows how to aggregate this data for charts.

**Examples/Scenarios**
* **Financial Reports:** A CFO needs a table showing "Total Expenses" grouped by "Department" (Rows) and broken down by "Month" (Columns).
* **Sales Performance:** A leaderboard showing "Total Revenue" and "Count of Deals" grouped by "Sales Rep".
* **Inventory Status:** A summary table showing "Stock Quantity" grouped by "Product Category" and "Warehouse Location".

**Why This Matters**
* **Completes the Reporting Suite:** Charts + Pivot Tables are the two pillars of any dashboard. Glide currently has one but lacks the other.
* **Data Density:** A Pivot Table can show much more information in a compact space than a bar chart.
* **No-Code Efficiency:** Eliminates the need for creating manual relation/rollup structures just to display a summary.

**Suggested UX**
* **Configuration:** Similar to the Chart settings.
* **Row Grouping (Dimension):** Select a column to group by (e.g., "Category").
* **Column Grouping (Optional):** Select a column to pivot horizontally (e.g., "Month").
* **Values (Measures):** Select columns to calculate (e.g., Sum of Price, Count of IDs).
* **Features:**
* **Grand Totals:** Option to show a Total row at the bottom and Total column on the right.
* **Drill-down:** (Nice to have) Clicking a number in the Pivot Table opens a list of the specific records that make up that number.

Image

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.