How do I count column text data?

Need help Database
1

Hello, How do I chart/count the same text items within a column?
image
I would like to count the occurrence of each type (Manager, IT, etc.). However, I am having trouble understanding Bubble’s Chart types.
Thanks, Chris

2

You will want to do a search for the rows that are in your columns and then select the :group by function on the search. Select the Role field and then add an aggregate then add an aggregate and select count. This is the data source for the chart.

1 Like
3

This worked! You da best.