Resolved: Incorrect Percentage Calculations on Course Registration Trend

Update 7/16/2026: Issue Resolved - 

The Course Registration dashboard has been updated in Campus Data Warehouse production to fix an issue that was causing incorrect capacity metrics for some courses. 

The issue was caused by duplicate course-level records in the Student Enrollment Aggregate - Snapshot dataset. The model was grouping records at a level that did not fully align with the dimensions being included, which caused some enrollment, waitlist, capacity, and percentage-of-capacity metrics to be aggregated incorrectly for certain courses.

The data model has been updated to better align the grouping logic with the underlying student enrollment snapshot data. The Course Registration dashboard calculations were also adjusted so enrollment, capacity, waitlist, units, and percentage-of-capacity metrics aggregate correctly across academic careers.

Users may notice that capacity metrics on this dashboard can differ from other course dashboards. This dashboard only includes courses where at least one student is enrolled in any section, and cancelled course sections may still be counted in total enrollment or waitlist capacity. This reflects the current population and grain of the pre-census snapshot model. A note to this effect has been added on each of the dashboard pages.

The issue with exporting the table with sparklines is a known QuickSight limitation due to the number of rows that are allowed in an Excel export. The export option has been disabled for the table with sparklines, but a note has been added, and users may switch to an alternative view that allows export at the course detail level.

The corrected dashboard can be viewed at:

Shared folders / Dashboards / Courses / Courses (Pre-Census Snapshots) / Course Registration

Incorrect enrollment and waitlist as a percentage of capacity metrics are appearing for some courses on the Course Registration dashboard in Campus Data Warehouse. Upon inspection of the issue, the data warehouse team has identified that duplicate records are appearing in the dataset for some courses, which is inflating the aggregate metrics for these courses. A fix for the issue has been identified and is in the process of development. 

GC0059526 - Incorrect Percentage Calculations on Course Registration Trend

On Course Registration > Courses Detail Report, the "Most Recent Enrollment as a Percentage of Enroll Capacity" is displaying incorrect numbers. See MATH 115 

Most Recent Enrollment: 76

Enrollment Capacity: 100

Most Recent Enrollment as a Percentage of Enroll Capacity: 1% 

should be 76 / 100 = 76% 

In addition, Export to Excel of the table is failing