[EuiDataGrid] Grouped rows and summary rows

[flash1293]

For some types of data it makes sense to collapse/expand some rows, not repeating the same value for this group and adding sub-summary rows for these groups

Kibana reference issue: elastic/kibana#61470

Open questions (this list is incomplete):

• Should this be possible in a nested way as shown in the screenshot or just feature a single level for collapsing/expanding?
• How is the functionality exposed? As rowspan/colspan and special styling plus everything else handled by the consumer or a more high level API?

[snide]

Grouping I think need to be handled very similar to Airtable with defined separation and exposed controls to provide the grouping. This aligns with our current toolbar driven approach.

[chandlerprall]

How is the functionality exposed? As rowspan/colspan and special styling plus everything else handled by the consumer or a more high level API?

Using row/col spans was my initial thought; would make sense to somewhere build a higher level component to manage the UI additions (from Dave's comment above) and the grouping / spanning logic.

I believe we'd also need to disable all in-memory functionality if there is any row/col span.

[github-actions]

👋 Hey there. This issue hasn't had any activity for 180 days. We'll automatically close it if that trend continues for another week. If you feel this issue is still valid and needs attention please let us know with a comment.

[github-actions]

❌ We're automatically closing this issue due to lack of activity. Please comment if you feel this was done in error.

[ghudgins]

re-opening as this issue is still blocking elastic/kibana#61470

[github-actions]

👋 Hey there. This issue hasn't had any activity for 180 days. We'll automatically close it if that trend continues for another week. If you feel this issue is still valid and needs attention please let us know with a comment.

[github-actions]

❌ We're automatically closing this issue due to lack of activity. Please comment if you feel this was done in error.