Help

Count unique number of attendees of events within a month

Topic Labels: Extensions
1042 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Tom_R
6 - Interface Innovator
6 - Interface Innovator

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.

0 Replies 0