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

nellalin · 2024-08-01T08:22:15.859Z

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 · 2024-08-01T08:40:53.597Z

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

nellalin · 2024-08-01T08:53:29.043Z

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?

image717×313 16.8 KB

Zeroic · 2024-08-01T10:22:54.067Z

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

system · 2024-10-10T08:22:54.149Z

This topic was automatically closed after 70 days. New replies are no longer allowed.