"Group By" in Table Element

Having the ability to group in the table element was a fantastic addition. My only complaint is that when a column is grouped, it is being duplicated. When I made it so the parent column was hidden to not have duplicated columns, it removed it from the grouped column dropdown since you can't group by hidden columns.

If we could either not duplicate columns, or better yet, be able to group by hidden columns, that would be perfect, and allow us to use this feature.

Also, it would be great if we could toggle which columns we want users to be able to group by. Most of the columns in our table don't make sense to group by.

Example with duplicate columns:

Example when I set the column to hidden when it is included in the group by aggregation (allCampaignsTable.groupByColumns)

Hi @Developers_Octane,


Thank you for flagging this issue!

We are looking into the duplicated column issue already, but I'll also ask the team to investigate why hidden columns don't show up correctly.

I noticed that you can group by hidden columns in the table's default settings, but, as you noted, it gets removed from the toolbar grouping

If we ship this, or the ability to choose which columns are available to group, I'll reach out here

Another idea - as a workaround in the meantime - is to use a custom toolbar button that opens a modal with a select component that triggers a setGrouping event on the table so the user can select which column to group

I actually noticed something interesting today. We have a portion of the app that uses the control component function on button click to set table grouping, and when you use that, it removes the duplicate columns. We are going to move forward with just that portion of the functionality for now and not roll out the Group By function to our entire team since this option does not give a lot of flexibility to our users to display data the way they need, and using it as it sits now created some confusion.

Like I mentioned before, if we could have the ability to toggle which columns we want users to be able to group by, and be able to group by hidden columns, that would be best case scenario for us.

Thank you for looking into it!

Oh interesting - I hadn't noticed that. Thank you for sharing!