RyanWorthen
6 years agoQrew Trainee
Report that Shows Individual Totals (NOT series totals) from Multi-Select Text
I have a form users fill out that asks which of nine options (from a multi-select text form field) apply. I need to be able to produce a report that shows the total counts for each of those nine options (so option 1 may have been selected 20 times, option 2 = 30 times, option 3 = 50 times, etc.). Currently, Quick Base is only showing me series totals (option 1 and 2, option 2 and 3, option 1 and 3, etc.) and that is not helpful info to me in this case.
How can I get each of my nine options to be valued by itself so I can show a pie chart that accurately demonstrates how many times each individual option has been selected?
How can I get each of my nine options to be valued by itself so I can show a pie chart that accurately demonstrates how many times each individual option has been selected?