Resolved Issue: Academic Program Health Degrees Academic Year Filters Not Updating

Update 9/25/2025:

The Degrees Awarded (Academic Years) visualizations on the Academic Program Health dashboard have been modified on both the Bachelor's - Degrees, Enrolls, Admits and Master's - Degrees, Enrolls, Admits dashboard pages so that the Academic Year filters will automatically update to include the most recent five academic years for which degrees census data are available. 

Original issue 9/10/2025: 

Academic Program Health - Bachelor's Degrees Academic Year Filter Not Updating Appropriately 

The Academic Program Health > Bachelor's - Degrees, Enrolls, Admits page is not updating the Degrees Awarded section to reflect the most recent academic year for which degrees census data is available (see attached). The reason is that there are two conflicting filters on the degrees visualizations: one for "Academic Year" with 2019-2023 hard-coded and another that is currently deactivated for "Degrees Academic Years to Include." The "Degrees Academic Years to Include" should be activated as it has appropriate logic to filter the most recent five academic years for which completed degrees census data is loaded. 

This will be an analysis change and migration only from STG to PRD.

Degrees Academic Years to Include

ifelse(

{Academic Year Numeric} > parseInt(${pAcademicYearDegree}), 'Exclude',

{Academic Year Numeric} <= parseInt(${pAcademicYearDegree}) AND {Academic Year Numeric} >= (parseInt(${pAcademicYearDegree})-4), 'Include', 

{Academic Year Numeric} < (parseInt(${pAcademicYearDegree})-5), 'Exclude',

'Exclude')

$pAcademicYearDegree=lastspringcensusacadyear_ersd (from Dynamic Default Table)