[Feature]: Pivot Table Widget

[Nikhil-Nandagopal]

Is there an existing issue for this?

• I have searched the existing issues

Summary

A user would like a widget that works as a pivot table to display data and be able to drill down on information

Why should this be worked on?

It's a community requested feature and we should prioritise it if more users request for it

[somangshu]

@Nikhil-Nandagopal could you explain the use case a bit more, Do you mean something like a DB join

[Nikhil-Nandagopal]

@somangshu a pivot table is like an interactable table widget where the end user can perform queries on the table, drilldown / rollup data etc.

[momcilo-appsmith]

@Nikhil-Nandagopal Is this something like excel's table?

[Nikhil-Nandagopal]

@momcilo-appsmith yes exactly. It's fairly complicated so I suggest we hold off till we have a few more requests for this

[vmulholl]

Hello, another advantage of pivot tables is simply for the easy of reading through collapsibility and grouping functionality like in Coda tables (see their grouping functionality). This avoids table data being repeated row by row, but obviously requires the "values" to be assigned an aggregation calculation (sum, count, average, etc.).

Why this is useful:

• better UX - gives a cleaner look and feel for the users when looking at larger amounts of data that would typically be grouped (e.g. monthly invoice records, grouped by user/type/category/any dimension, etc.)
• maintains the search functionality from the table widget which is extremely useful

Just wanted to let you know that we would definitely use this feature to improve the user experience in our apps. Thanks for your support!
Vero

[Nikhil-Nandagopal]

Thanks for the wonderful information @vmulholl !