perspective icon indicating copy to clipboard operation
perspective copied to clipboard

Is it possible to not display the TOTAL row in the datagrid view?

Open Tomtomgo opened this issue 4 years ago • 3 comments

If we look at the example on the Perspective homepage, there is a "TOTAL" row for aggregates:

Screenshot 2020-09-28 at 14 21 39

Is there a way to not display this row?

Tomtomgo avatar Sep 28 '20 12:09 Tomtomgo

Not currently, but the data engine supports an undocumented leaves_only parameter for pivots that only output the leaf rows which would be somewhat straightforward to implement in the UI. In code, you can use this parameter directly to pivot a dataset, then load the resulting view into your perspective-viewer.

I'm going to go ahead and use this Issue to track this feature.

texodus avatar Mar 27 '21 01:03 texodus

Tagging @franher because he mentioned that he was looking to contribute, and I think this would be an awesome contribution. Maybe all we need is an implementation of @texodus 's recommendation above added to the examples?

riziles avatar Apr 15 '23 23:04 riziles

You can do something like this https://github.com/perspective-community/perspective-viewer-datagrid-norollups Note that this does not use leaves_only, it somewhat inefficiently just blanks out the rows after

timkpaine avatar Aug 08 '23 22:08 timkpaine