Displaying event stats

Need help Database
1

Hello,

What im trying to do is display event details from “Select Event to Validate” which is selecting the event to display.

And in event stats, there is 5 different things im trying to display.

Total Registered → Total Users registered for the event.

Checked-In → Number of users checked-in

Checked-Out → Number of users checked-out

Not Checked-In → Number of users not checked-in

Capacity → total tickets limit (working fine)

The thing is I have 3 different things where the data will be taken from:

  1. Event

  2. Ticket

  3. User

Event → Ticket → User

ex: Parent group event’s ticket’s user’s full name

I tried multiple ways to display the count but nothing worked. if anyone can help, I can send you the editor link so you can check the data’s.

2

If you arent adding the tickets back to the event then the array would be blank

Try using Do a search for Tickets where event = your event and count that result