More actions
Univ Grad % represents the percentage of students across the university that have graduated and are no longer enrolled.
| Metadata | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Data Custodian | |||||||||
| {{{Department}}} | |||||||||
| Data Source | |||||||||
| |||||||||
| Logical Transformation / Calculation | |||||||||
| REPORT_AGGREGATE(100*count(distinct case when "SIA - Student Records - Class Enrollment"."Dim - Cohort Fac-Stdnt Success"."Enrolled Count"=1 then "SIA - Student Records - Class Enrollment"."Scholar"."Scholar Number"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Subject Code"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Catalog Number"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Class Section Code"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Term Code" else null end)/count(distinct case when "SIA - Student Records - Class Enrollment"."Dim - Cohort Fac-Stdnt Success"."Graduated Count"=1 or "SIA - Student Records - Class Enrollment"."Dim - Cohort Fac-Stdnt Success"."Enrolled Count" =1 or "SIA - Student Records - Class Enrollment"."Dim - Cohort Fac-Stdnt Success"."Not Grad Enrolled Count"=1 then "SIA - Student Records - Class Enrollment"."Scholar"."Scholar Number"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Subject Code"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Catalog Number"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Class Section Code"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Term Code" else null end) BY "SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Term Descr", case when "SIA - Student Records - Class Enrollment"."Dim - Cohort Fac-Stdnt Success"."EOP"='Enrolled' then 'Yes' when "SIA - Student Records - Class Enrollment"."Dim - Cohort Fac-Stdnt Success"."EOP"='Not Enrolled' then 'No' ELSE 'Unknown' end) | |||||||||
| Dataset Folder and Field Name | |||||||||
| |||||||||