Skip to main content

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.

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


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))

 


Reply