Consolidate values from a multi-select text field in a chart

  • 0
  • 3
  • Question
  • Updated 3 years ago
  • Answered

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 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. 

Photo of DRL

DRL

  • 20 Points

Posted 3 years ago

  • 0
  • 3
Photo of John Michael

John Michael

  • 20 Points
Hey,

Thanks for posting to the QuickBase community forum!  Unfortunately as of right now there is no native way in QuickBase to collate the data for each value but I can send you a link to our partners and they may have a third-party solution for you.

http://quickbase.intuit.com/partners