How long has each student really been enrolled?
Drop your Jackrabbit Enrollment Detail Report below and we'll do the math for you — merging overlapping enrollments to give you clean per-student tenure numbers. Continuous days, longest streak, gaps — all of it.
| Student | Enrollments | First Enroll | Last End | Continuous | Total Active | Longest Streak | Gaps | Longest Gap |
|---|
How these numbers are calculated
The Enrollment Detail Report from Jackrabbit gives you a complete record of every class enrollment — exactly what you need when you want the details. This tool reads that same data and rolls it up to one row per student, so you can answer per-student questions like "how long have they been with us?" at a glance.
Canonical window: each enrollment runs from Enroll Date to Drop Date (or today, if still active). The class's own start/end dates are ignored — those describe when the class meets, not when the student is enrolled.
Continuous Days merges overlapping enrollment windows per student into a single timeline, then counts distinct days. This is the number that answers "how long has this student been with us?"
Total Active Days sums every enrollment window without merging — the same number you'd get from summing durations directly. The gap between this and Continuous Days shows how much overlap a student has across their classes.
Longest Streak is the longest single uninterrupted enrolled period. Gaps are the days between merged periods — useful for spotting students who lapsed and came back.
Join key: students are grouped by Jackrabbit Student ID, not name. (Name collisions would silently corrupt the math.)