Help

How to calculate growth rate of attendees?

Topic Labels: Formulas
199 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Connor_Forsyth
4 - Data Explorer
4 - Data Explorer

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