Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Feb 27, 2022
I am running an event/webinar series, and I’m wanting to identify the total number of people attending the event for the first time (as to get an indication of growth).
I have two linked bases
Key information I believe required (that I have):
My thinking was to create some sort of formula as you see in this image below:
(However, you cannot dynamically link a date from the base into the date field in this image.
~ Essentially my logic is:
Count attendees if this is their first event.
– Get dates of the events
–List dates that attendee was at an event.
– Get an event date
–If the attendee Does not include dates before event in testing. Count. ~ Aggregate and sum of growth is printed.
Any tips on how I can make this happen?