Resolved: Course Grades Overview - Earning Credit % Problem

Resolution update 9/4/2025:

The Course Grades Overview Earning Credit % metrics in the visualizations are now working as expected.

Class Enrollment Dataset and its children were updated and migrated from STG to PRD.

Original issue:

On the Course Grades Overview, the "Not Earning Credit Percentage" and "Earning Credit Percentage" metrics do not sum to 100%. They vary consistently by a few hundredths or tenths of a percentage point compared to manual calculations using the counts of those "Not Earning Credit" and "Earning Credit".

Upon closer examination of the dataset calculated fields, these appear to require modification:

Earning Credit existing calc:

sum({Earning Credit Count}) / distinct_count({Unification Id})

Not Earning Credit existing calc:

sum({Not Earning Credit Count}) / distinct_count({Unification Id}) The "distinct_count" on Unification Id appears to be resulting in slight variations in the percentage calculations compared to calculating manually. Suggest replacing distinct_count({Unification ID}) with Class Headcount, which is calculated as count({Unification ID}). I also think this issue is related to the known issue we have with FSSD integration, resulting in duplicate records in Class Enrollment