Improved group by multi-select column

There is one UX behaviour that bothers me. It’s the way grouping works with multi select data.
It “merges” multi selected fields (if more than one value is selected), and therefore creates a new value for grouping. I can imagine that from the design perspective, that might be a straightforward solution. From UX standpoint it might be not the user intent.
Imagine freelance developers capable of using different frameworks/languages. Let’s assume “Developer A” is fluent in both “python” and “ruby”.
I group them by “language”. In 9/10 scenarios I would be looking for a single language, in 1/10 I would be looking for a person that Person being both a python and ruby dev.
At this point, grouping by “language” would make every possible permutation of “languages” a single group. Person knowing “js” & “python” & “ruby”, would not be in the same group as a person that know “python” & “ruby”.
If I were to look for “python” devs I could not use a group by card view, since they would be all over the place, an UI hides the information about “multi select” used making it +1 or +2. I would love to see “DevA” in all the columns he should be (both, python and ruby in this example)

I get the logic behind the current state, but for my use cases it’s sub optimal. I believe ability to pick grouping behaviour (combine the multiselect, or split the multiselect) would be great.

A little image of the current behaviour :frowning:

5 Likes

Well written suggestion, totally agree!

2 Likes

Thanks for taking the time to submit this suggestion. I also want to see this updated.
My use case is grouping projects by value. My leaders want to know what all projects are contributing to their goals. Some projects check multiple boxes. I want those projects to show up under multiple goals, not have one grouping with all the value selections.

1 Like

Also facing the same case here. I agree with OP.


I really think this is a matter of setting up your tables properly. My language table has a (hidden) column (linked relation to Developers, Name), which is setup by point and click -
although it is actually a simple formula:

Developers.Filter(Languages.Contains(thisRow))

Then make a view of the language table, top-group on language and you have exactly what you are asking for.
Personally I think grouping works as expected.

4 Likes