Skip to main content
Question

Assistance needed with data collection

  • July 18, 2025
  • 2 replies
  • 43 views

Forum|alt.badge.img+1

Hi useful people,

 

Our Airtable database contains multiple services with attendance data. We also log the individual names of each attendee. Airtable can easily gather the total about of attendees across a period of time - my question is, how does Airtable gather the individual data?

 

For example, Airtable may tell us that there were 1000 attendees across a calendar year, but how many many of those are the same people? What we’re looking for is the amount of individuals who have accessed the service in the calendar year, not a total attendance tally. 

I hope that makes sense… thank you in advance.

2 replies

felipe-saucedo
Forum|alt.badge.img+10

You can use array unique rollup. And it will get you only unique values, then you can have a formula to calculate those. 


TheTimeSavingCo
Forum|alt.badge.img+31

I think you’ll need a new table where each record represents a single year I'm afraid, and I’ve set it up here for you to check out

And the formula for the rollup field is:

COUNTALL(ARRAYUNIQUE(values))