dash-table icon indicating copy to clipboard operation
dash-table copied to clipboard

Built-in Summary Row that Responds to Filtering, Sorting, and Editing

Open vishnuvvn opened this issue 6 years ago • 8 comments

We are trying to bring in a summary row for all the number columns. Looks like this is not possible in this version.

vishnuvvn avatar May 14 '19 15:05 vishnuvvn

This would have been a nice feature to have. I see this being asked on the dash plotly forum in Oct 2018 (https://community.plot.ly/t/data-table-how-to-get-sum-of-column-s/14790), but haven't seen any update there.

threemonks avatar Jul 29 '19 03:07 threemonks

Did you find any solution?

AnastasiyaDemi avatar Apr 03 '20 09:04 AnastasiyaDemi

@AnastasiyaDemi I have been searching for this as well to no avail. I can't find a way to get a simple summation column to work with an editable table.

njlustigpk avatar Apr 14 '20 02:04 njlustigpk

Can someone share an example of what this looks like? It's not clear to me why you wouldn't be able to compute this in Pandas and display it as the first row, or even as a second header?

chriddyp avatar Apr 14 '20 03:04 chriddyp

I will put together a contrived example this weekend. You can calculate the summation column just fine with pandas the first time. The issue is that since the table is editable, the summation column doesn't update accordingly when a user changes the value in one of the cells.

njlustigpk avatar Apr 14 '20 14:04 njlustigpk

Even with read-only table, one can expect the sum to change when a filter is applied on one or more columns, as the sum would be the result of only the rows shown after filtering.

On Tue, Apr 14, 2020 at 10:08 AM njlustigpk [email protected] wrote:

I will put together a contrived example this weekend. You can calculate the summation column just fine with pandas the first time. The issue is that since the table is editable, the summation column doesn't update accordingly when a user changes the value in one of the cells.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/plotly/dash-table/issues/433#issuecomment-613464899, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABISJHRJ2IKBTAFZRUJ74TTRMRU6NANCNFSM4HM3JNFA .

threemonks avatar Apr 14 '20 14:04 threemonks

Hi, has anyone found a solution for this?

emazika avatar Jul 15 '20 08:07 emazika

Hi any update regarding to that?

ShamkhalHajiyev avatar Sep 03 '21 07:09 ShamkhalHajiyev