Reports
Attendance after (or during) an event, in people — Admin → Events → Reports, and a Viewer's home.
Who opens it: organizers the morning after, group leads counting their own people, finance and viewers answering "how many came?".
What they came to do: get numbers they can trust and hand on — who came, who did not, who only pre-checked, who was there only with their family — and a list to fix what does not add up.
What must be true when they leave: the numbers add up, count people rather than tickets, and a file they download shows times in the event's own timezone.
Decided
- Choose the event and the day.
- Registered is everyone expected at the day, plus anyone with a check-in for it however they got in (an override, a ticket voided after they were admitted). It is split into Attended, Pre-checked only, Present with household only and No-show; the four always add up to it (Pilot Day, C6).
- Until the day has ended, the last column is Not yet arrived instead of No-show.
- Export attendance by day (button at the top) writes every day of the event into one file, one row per person per
day, in long format: last name, first name, email, day, room, first scan, last scan, minutes, status. Long format
pivots in a spreadsheet in seconds and does not break when a day is added. Names are made safe to open: one that begins
with
=shows as text. - Minutes come from the paired In and Out check-in points (see Check-in points). If someone forgets to scan out, what the open stretch is worth is the event's If someone forgets to scan out setting: assume they stayed until the day ended (the default), count nothing, or count it and mark it Unverified. Status is Complete or Unverified.
- Attendance record (a button on a person's page) is one person's days in order — room, first and last scan, time and Complete or Unverified — with a total. Download it as a CSV, or as a one-page PDF certificate to send them, made from the Certificate template (Templates → search "certificate"), which an organizer can edit; time that no exit scan confirmed is starred and the page says so. It uses the same hours as the by-day file, so the two never disagree.
- Breakdowns by group, by type, and attended by check-in point.
- A group lead sees only their groups' people.
- Tickets scanned more than once and Overrides (with the reason and who gave it) are there for reconciling.
- Export any list as CSV or Excel; a large one arrives by email as a link that works for a day. The list's day column is Day. An Excel file of an attendance list also carries By group, By type and By check-in point sheets, the same numbers as the tables on screen; a CSV file holds the list only.
Open
- Marking no-shows at event close as a status (today the list is simply final once the event is closed).
- A cross-day "attended any day" view.