It would be great if we could group by a transformation of a column. For example if I have a column with values "[ABC] 123", "[ABC] 456", "[GEH] 678" I want to be able to group by "[ABC]" and "[GEH]".
A current workaround is to add a duplicate column with the transformed data and group by that.
Nice idea - thanks for this. Using rowGroup.dataSrc as a function would provide this ability. We'll add that ability and write up a blog post about this early in the new year.
It would be great if we could group by a transformation of a column. For example if I have a column with values "[ABC] 123", "[ABC] 456", "[GEH] 678" I want to be able to group by "[ABC]" and "[GEH]".
A current workaround is to add a duplicate column with the transformed data and group by that.