How do I count column text data?

chris348maer · 2020-12-22T06:58:18.191Z

Hello, How do I chart/count the same text items within a column?

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

jdiaz · 2020-12-22T13:31:57.648Z

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.

chris348maer · 2020-12-24T01:28:19.222Z

This worked! You da best.