19th November 2025 — AGM Statistics Report #17

build 361 — commit c8dd64

This originated from the frequent need of committee members to obtain statistics about the prior years group activities in order to produce reports for the annual group AGM. The AGM Statistics Report can be accessed from Admin → AGM Statistics (/admin/members/agm-stats) as can be seen in the screenshot below. The report is organised into 4 tabs as follows:

Walks Tab

Socials Tab

Membership Tab

• Shows historical membership trends using bulk-load audit snapshots and deletedMembers collection

Expense Tab:

• Add Total Paid, Total Unpaid, and Total Cost (sum) rows to expense summary table
• Calculate unpaid expenses from expense claims without "Paid" events
• Filter unpaid expenses by date range per year for accurate per-period totals
• Collapsible "Unpaid Expenses" section showing all outstanding expense claims
• Display unpaid items with sortable columns: Claimant, Description, Amount, Date
• Include item count in section header

General

• Charts are based on a rolling 1-year period chunking (backwards from "To Date") across all tabs for consistent old→new ordering
• Date Range Preset can be used to quickly select a From Date and To Date up to All time
• In the Chart Type dropdown you can also select Line Chart in order to more easily see historic trends: