Hi Guys,
I have three tables:
{Attendee table}
{Bridge table}
{Event table}
The {Bridge table} is where we check in attendees to an event by using two fields:
Select the event from a linked record field (links to {Event Table})
Select the attendees from a linked record field (links to ‘{Attendee table}’)
The only record we create during this process is within the {Bridge table}, the records in {Attendee table} and {Event table} already exist.
In the {Event table} we have the a date field with an additional formula field calculating the month the event occurred.
My aim is to create a chart block to count the number of attendees who attended at least one event during a given month, as an attendee can attended one or more events per month (this is easy enough to calculate with blocks).
I cannot figure out how to do this, any ideas? Have I missed something super obvious?
Thanks.
