More actions
Dept Grad % represents the percentage of students in a given subject that have graduated and are no longer enrolled.
| Metadata | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Data Custodian | |||||||||
| {{{Department}}} | |||||||||
| Data Source | |||||||||
| |||||||||
| Logical Transformation / Calculation | |||||||||
| SET VARIABLE DISABLE_CACHE_HIT=1;select 100*cast(count(distinct case when "Dim - Cohort Fac-Stdnt Success"."Graduated Count"=1 then "Scholar"."Scholar Number" else null end)as double) /cast(count(distinct "Scholar"."Scholar Number") as double) FROM "SIA - Student Records - Class Enrollment" WHERE ("Dim - SIA - Academic Class-FSSD"."Term Descr" in (@{MyStudVar3})) AND (NOT "Grade"."Grade Code" = '__NOT_APPLICABLE__') AND ("Dim - SIA - Academic Class-FSSD"."Subject Code" IN (@{MyStudVar5}['@'])) | |||||||||
| Dataset Folder and Field Name | |||||||||
| |||||||||