Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Count unique values in a column

Topic Labels: Automations Data Formulas Views
Solved
Jump to Solution
1259 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Lisa_Wetherby
6 - Interface Innovator
6 - Interface Innovator

I have a grid view with a field that shows volunteers that have volunteered along with the date they volunteered

Lisa_Wetherby_0-1712696136417.png

I want to figure out how many volunteers volunteered each month - how do I find how many unique volunteer names appear in this list, and if I filter for the specific month, will it still work?

Thank you!

 

2 Solutions

Accepted Solutions
jsep
7 - App Architect
7 - App Architect

You can create a "Months" table, which will contain the list of months.

In the "Months" table, create a lookup field to the table where you keep track of volunteers. You can set up an automation to automatically link each time someone volunteers.

Then, you can simply create a Rollup field that will count the unique volunteers.

Example formula:

COUNTAll(ARRAYUNIQUE(values))

Result:

jsep_0-1712744642464.png

If you need more help feel free to schedule call with me.


 

See Solution in Thread

Alexey_Gusev
12 - Earth
12 - Earth

Hi,
For a quick look, you can choose unique

Alexey_Gusev_0-1712851682478.png


and group by month with 'Collapse all'

Alexey_Gusev_1-1712851782773.png

But if you want to use these numbers per month, you should follow link provided by @Ella  




See Solution in Thread

4 Replies 4
Ella
7 - App Architect
7 - App Architect

If you create a linked record and a roll-up field then you could use the solution in this post (https://community.airtable.com/t5/show-tell/count-unique-values-in-rollup/m-p/113668#M1834) potentially.

jsep
7 - App Architect
7 - App Architect

You can create a "Months" table, which will contain the list of months.

In the "Months" table, create a lookup field to the table where you keep track of volunteers. You can set up an automation to automatically link each time someone volunteers.

Then, you can simply create a Rollup field that will count the unique volunteers.

Example formula:

COUNTAll(ARRAYUNIQUE(values))

Result:

jsep_0-1712744642464.png

If you need more help feel free to schedule call with me.


 

Alexey_Gusev
12 - Earth
12 - Earth

Hi,
For a quick look, you can choose unique

Alexey_Gusev_0-1712851682478.png


and group by month with 'Collapse all'

Alexey_Gusev_1-1712851782773.png

But if you want to use these numbers per month, you should follow link provided by @Ella  




Thank you! That is a simple way to get what I need - which works for me!