Scenario
The VP of Enrollment needs to see how many applicants sit at each status stage (New, Accepted, Deposited, etc.) for each start term to evaluate the admissions funnel.
Expected output
Multiple rows showing the applicant count at each status for each start term, sorted chronologically by the term's start date, then by count descending.
appl_start_termappl_current_statuscurrent_status_descapplicant_count
Tables
ods_applications ods_terms
Hints
Hints are a Pro feature. Upgrade