Help

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.

How to calculate growth rate of attendees?

Topic Labels: Formulas
175 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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

  1. The event series
  2. the attendees

Key information I believe required (that I have):

  • Date of each event
  • Event name
  • Attendee name
  • Attendees assigned to events
  • Total attendees at the event

image

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.
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?

0 Replies 0