Skip to main content

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 :

Dog1
Cat3
Bird2

Instead, Airtable's barchart interface counts these responses as:

cat1
cat, bird1
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?

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


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


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.


Reply