Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

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

Topic Labels: Interface Designer
Solved
Jump to Solution
1253 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.