Forum Discussion

RyanWorthen's avatar
RyanWorthen
Qrew Trainee
6 years ago

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?
  • The only way to do this will be to Auto create child records matching the Multi select checkboxes.

    You would create a child record to hold these and do the chart off the child table.  

    The Automation would trigger when the parent is edited or added and that multi select field changed.

    The Automation would delete all the existing children.
    Then add nine new children
    then delete children not needed.  It would have a formula field on the children which would compare a lookup of the multi select field to the record to detect if the child was legitimate and should stay or be deleted.