Resolved: Retention and Graduation Detail Entering Cohort Tracking Metrics

Update (November 13, 2026): The Retention and Graduation Detail dashboard has been updated to correct the Enrolled and Neither Enrolled Nor Graduated metrics on the Entering Cohort Tracking tab. 

The issue was identified while reviewing the Fall 2017 entering cohort of Upper Division Transfer state-supported students and comparing Entering Cohort Tracking with the Multilevel Crosstab Table, Enrollment Census, and Degrees Census data. 

When comparing Entering Cohort Tracking with Retention metrics elsewhere on the dashboard, users should account for students who were both enrolled and graduated during the selected cohort period. On Entering Cohort Tracking, the Enrolled and Graduated values summed together for the cohort year and term should align with the corresponding retention metrics as students can be both enrolled and graduate in the same cohort year and term.

Before the fix, the Entering Cohort Tracking values did not consistently reconcile with the Retention totals on other dashboards. For example, the Fall 2017 cohort showed a discrepancy beginning with the Year 02, Term 03 column.

Before the update:

Comparison of Fall 2017 retention metrics in the Multilevel Crosstab Table and Entering Cohort Tracking, with red boxes highlighting corresponding totals. The screenshot also shows Degrees Census counts matching the Graduated values.

After the calculation was corrected and migrated to production, the Enrolled and Neither Enrolled Nor Graduated metrics now reconcile with the corresponding Retention totals. For the same cohort, the corrected values include:
  • Year 01, Term 03: 728 Enrolled + 1 Graduated = 729
  • Year 02, Term 01: 644 Enrolled + 18 Graduated = 662
  • Year 02, Term 03: 297 Enrolled + 338 Graduated = 635
  • Year 03, Term 01: 143 Enrolled + 118 Graduated = 261
  • Year 03, Term 03: 36 Enrolled + 100 Graduated = 136

After the update:

Corrected Entering Cohort Tracking metrics for the Fall 2017 cohort. Red boxes highlight Enrolled and Graduated counts that sum to the corresponding retention totals: 729, 662, 635, 261, and 136.

The updated metrics are now available in Campus Data Warehouse production.

Dashboard: Retention and Graduation Detail
Tab: Entering Cohort Tracking

Please submit a Campus Data Warehouse ticket if you identify any additional discrepancies.


GC0130706 - Retention and Graduate Detail, Entering Cohort Tracking tab: metrics "Enrolled" and "Neither Enrolled Nor Graduated"

In reviewing a potential discrepancy I reported, Michael Dorsch indicated after accounting for known/expected differences he was, "still seeing some discrepancy when adding "Enrolled" and "Graduated" together on Entering Cohort Tracking when comparing with the Retention metrics on other pages." and "there seems to be something off about the "Enrolled" and "Neither Enrolled Nor Graduated" metrics on the Entering Cohort Tracking analysis."

Please see attached email thread for full details, including screenshots and which dashboards and tabs were compared.