How to Display the Count of Items in an Option Set Using Chart Element in Bubble.io?

[nellalin]

Hi everyone,

I have a User table where each user’s accept_industry field is a list of options from an option set called industry. This option set has 10 pre-defined choices.

Each user may select multiple options in the accept_industry field.

I would like to create a chart using the Chart Element in Bubble.io that displays the count of users who have selected each option in the accept_industry list. Additionally, I would like the chart to show the percentage distribution of these selections.

Could anyone guide me on how to properly set up the data source, grouping, and chart settings to achieve this? Detailed steps would be greatly appreciated.

Thank you!

[Zeroic]

You can use the :group by operator in Bubble to achieve this

[nellalin]

I tried. As you can see, I can select a field for “group by”, if the field is NOT a list of things. I can not find “accept_industry” because it is a list of Option Set “industry”.

Any other thought?

[Zeroic]

Gotcha - you could use a different charts plugin then. I know of 📊 Apex Chart - 54 Charts & Graphs Plugin | Bubble where you can pass your data as a JSON which would be ideal for your use-case