I'm trying to configure a bar chart in interface designer to show the count of each choice from a multiple choice field.
For example, if the choices are: dog, cat, bird
And I have respondents that selected:
I'd expect to see a bar chart that has values :
Instead, Airtable's barchart interface counts these responses as:
|dog, cat, bird
Is this a limitation of the interface feature, or is there a way to display the count of each choice in a multiple choice field?
Solved! Go to Solution.
Thanks for the example!
You confirmed I was doing things right in Airtable, which led me to dig deeper.
I was trying to import an Excel spreadsheet that used ; as a delimiter instead of a ,
Once I fixed that, Airtable treated multiple choice responses properly and my dashboard works.