Breaking out a user list to individuals when creating a chart

This is the best that i can think of ... https://quickbase-community.intuit.com/questions/1378892-i-want-to-create-a-chart-based-on-information-in-a-multi-select-text-field-however-it-is-showing-each-permutaion-and-i-want-it-to-show-each-choice

Thanks for the link. It could work I suppose, but I'm dealing with almost 80 users, so I'm hoping there is something out there I can do that is more concise.

Well, we will wait to see if someone has a less worse idea. I posted my response as a Comment and not as an Answer, so it remains unanswered I too am looking for a bright idea.

Just wanted to chime in with my very ugly possible solution, as I have the same issue. I'm thinking about creating a webhook or workato automation that will generate a record on a child table for each user listed in the parent field, and then relating down all relevant fields. I will then create all reporting on the child table as now each record will have the unique value to tally up + the related fields will always be updated from the parent. (I have been thinking about this scenario for months, and this is the best I could come up with, hopefully it helps someone.)