
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 13, 2023 06:55 PM
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:
- respondent 1: cat
- respondent 2: cat, bird
- respondent 3: dog, cat, bird
I'd expect to see a bar chart that has values :
Dog | 1 |
Cat | 3 |
Bird | 2 |
Instead, Airtable's barchart interface counts these responses as:
cat | 1 |
cat, bird | 1 |
dog, cat, bird | 1 |
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 13, 2023 11:55 PM
Weird, it seems to work the way you want for me:
Here's a link to the base if you'd like to have a look
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 13, 2023 11:55 PM
Weird, it seems to work the way you want for me:
Here's a link to the base if you'd like to have a look

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 14, 2023 08:22 AM
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.
