Trying to create a pie chart with values from a multi-select text field. The field "Requested by" has values Company A, Company B, Company C etc... (up to 10 of these) Currently when in the chart I get a value for each permutation of selections - like this:
Company A; Company B; Company F
Company C; Company D; Company G
I'd like to be able to collate the data for each value. So my chart would just show the % for each value in the multi-select field.
My users are a mix of Mac and PC's so I need a solution that will solve for all.
Anyone have thoughts? This makes the multi-select text option not very valuable for charts as I can end up with way too many variations.