Help

Table showing count of multiple choice field not working in Interface Designer bar chart

Topic Labels: Interface Designer
Solved
Jump to Solution
1137 2
cancel
Showing results for 
Search instead for 
Did you mean: 
James_McElroy
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Weird, it seems to work the way you want for me:

Screenshot 2023-02-14 at 3.54.55 PM.png

Screenshot 2023-02-14 at 3.54.36 PM.png

Here's a link to the base if you'd like to have a look

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Weird, it seems to work the way you want for me:

Screenshot 2023-02-14 at 3.54.55 PM.png

Screenshot 2023-02-14 at 3.54.36 PM.png

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.