New to Airtable here and trialling to see if I can work out a solution for my department.
I have two bases, one that tracks People and the other that tracks Activities. Within Activities are fields for 'Participants', 'Facilitators' and 'Guests'. Multiple people can be added to each field.
I am trying to create an interface that shows a count of how many people there were across all activities in the participant's column. However, I can only seem to get it to count how many activities there were to have any participants, which is a different number.
I can see the next trap would also be that, if I was able to get it to count items within a column, it would count them regardless if they were original or not. This is desirable sometimes but it would be good to only count unique entries across multiple activities because often the same people attend multiple activities. How do I effectively say "count unique entries within the participants' column for all activities"?