feat: "Group" column for rollup/tree tables

[mofojed]

• Have a virtual column that just shows the rolled up value
• Displays the value from the "source" cell (ie. the value from the grouping column at that depth)
• The context menu shows the filter options for the source cell, so you can filter by options
• Virtual column you cannot use quick filters or sort on
• Closes Option to show rollup grouping values only on the 'rolled-up' row #1555
• Tested with rollup from docs:

from deephaven import read_csv, agg

insurance = read_csv("https://media.githubusercontent.com/media/deephaven/examples/main/Insurance/csv/insurance.csv")

agg_list = [agg.avg(cols=["bmi", "expenses"])]
by_list = ["region", "age"]

test_rollup = insurance.rollup(aggs=[], by=by_list, include_constituents=True)
insurance_rollup = insurance.rollup(aggs=agg_list, by=by_list, include_constituents=True)

[codecov]

Codecov Report

Attention: 144 lines in your changes are missing coverage. Please review.

Comparison is base (9d519e1) 46.74% compared to head (8187250) 46.65%.

Files	Patch %	Lines
packages/iris-grid/src/IrisGridTreeTableModel.ts	1.88%	52 Missing ⚠️
...d/src/mousehandlers/IrisGridContextMenuHandler.tsx	0.00%	38 Missing ⚠️
...ckages/iris-grid/src/IrisGridTableModelTemplate.ts	11.11%	16 Missing ⚠️
packages/iris-grid/src/IrisGrid.tsx	0.00%	12 Missing ⚠️
packages/iris-grid/src/IrisGridModel.ts	25.00%	12 Missing ⚠️
packages/iris-grid/src/CrossColumnSearch.tsx	0.00%	7 Missing ⚠️
packages/iris-grid/src/ColumnStatistics.tsx	0.00%	3 Missing ⚠️
packages/iris-grid/src/IrisGridProxyModel.ts	50.00%	2 Missing ⚠️
.../mousehandlers/IrisGridColumnSelectMouseHandler.ts	0.00%	2 Missing ⚠️

Additional details and impacted files

@@            Coverage Diff             @@
##             main    #1636      +/-   ##
==========================================
- Coverage   46.74%   46.65%   -0.10%     
==========================================
  Files         606      606              
  Lines       36762    36852      +90     
  Branches     9227     9255      +28     
==========================================
+ Hits        17184    17192       +8     
- Misses      19526    19608      +82     
  Partials       52       52              

Flag	Coverage Δ
unit	46.65% <12.19%> (-0.10%)	⬇️

Flags with carried forward coverage won't be shown. Click here to find out more.

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

[mattrunyon]

The organize columns menu shows the group column name (although that may need to be unique right now and can be fixed separately)

I tried to add an aggregate column and it crashed my table

Linker can connect to/from the group column. Doesn't crash the table, but does create an invalid textbox if it's the receiving side of a link

[mattrunyon]

Also shows up in the find column menu

[mattrunyon]

Still an issue that you can link into/out of the virtual column. At least for the link into, it creates an invalid filter on the column which is unclearable unless you use the clear all filters keyboard shortcut (ctrl+e).

Linking out works, but feels odd since it's the key column and can have multiple types. I'd say just don't make it a linkable column at all

[mattrunyon]

Just need to fix the linker issue