How to create a count summary of values in a table?

Hey guys, I have this survey response table where people would share how they found us. I’m using Coda AI to categorize them in the 3rd column here

What is the best way to create a summary (sort of like a pivot table) listing out all the values from this 3rd column (Referral category) along with the count (how many times this value was mentioned)?

Using the filter formula is the way to go.

If you share your doc, i can create it for you.

Sincerely
Jannis

If your select list doesn’t already refer to a table of options, there’s a button in there to convert your options list to a table. After you do that, you can add a column to options table, and for type, choose referenced by > the first table. This will give you a list of items that chose that option. Then you can add another column that does [the column of things that chose this option].Count()

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.