My first test was to use it on a multi-select column; the results are not ideal and I don’t have a way to change it. Basically, the current pie is pulling each combination of multi-selects as it’s own section, while I want to see the % for each multi-select option separately regardless of how certain cells are populated.
Thanks @Nicole_Tschorn and sorry to hear your first use was less than ideal. This is a known limitation of charts right now with multi-item data types such as Multiselect, Users, and Related rows. Support for charts considering discrete items within these cells as separate data points, versus as a unit, is on our short-term roadmap. We’re tentatively planning to provide an option to choose which behavior you want.
We’ll update this thread as soon as we have an ETA to share.
This worked perfectly and I learned something new, so thank you
One follow-up question: It seems the data for “Urgent Need” didn’t get labeled on the chart; wondering if it’s a bug or a setting? It shows the name if I hover over the segment, but as you can see it’s not on the chart itself, only the percentage.
A much simpler solution: The ability to “Count options separately” for Multiselect columns in Charts, as well as other multi-option data types, is now available as of our Feb 18th release.