...
| Panel |
|---|
LISTAGG(CASE WHEN M.STDNT_GROUP IN ('SEEK') THEN 'SEEK' WHEN M.STDNT_GROUP IN ('PATH') THEN 'PATH' WHEN M.STDNT_GROUP IN ('HPNS', 'HREG', 'PROV', 'BSCH', 'DSCH') THEN 'HONORS' ELSE 'NULL' END, ', ') WITHIN GROUP (ORDER BY CASE WHEN M.STDNT_GROUP IN ('SEEK') THEN 'SEEK' WHEN M.STDNT_GROUP IN ('PATH') THEN 'PATH' WHEN M.STDNT_GROUP IN ('HPNS', 'HREG', 'PROV', 'BSCH', 'DSCH') THEN 'HONORS' ELSE 'NULL' END) |
Ethnicity:
User can use this as a CF field
Image Added
| Panel |
|---|
LISTAGG(CASE WHEN P.ETHNIC_GROUP IN ('1') THEN 'WHITE'
WHEN P.ETHNIC_GROUP IN ('2') THEN 'BLACK'
WHEN P.ETHNIC_GROUP IN ('3') THEN 'HISPANIC'
WHEN P.ETHNIC_GROUP IN ('4') THEN 'ASIAN'
WHEN P.ETHNIC_GROUP IN ('5') THEN 'AMERIND'
WHEN P.ETHNIC_GROUP IN ('6') THEN 'NON-HISPANIC/NOT-SPECIFIED'
when P.ETHNIC_GROUP is null then 'Not Provided'
ELSE 'OTHER' END, ', ') WITHIN GROUP (ORDER BY
CASE WHEN P.ETHNIC_GROUP IN ('1') THEN 'WHITE'
WHEN P.ETHNIC_GROUP IN ('2') THEN 'BLACK'
WHEN P.ETHNIC_GROUP IN ('3') THEN 'HISPANIC'
WHEN P.ETHNIC_GROUP IN ('4') THEN 'ASIAN'
WHEN P.ETHNIC_GROUP IN ('5') THEN 'AMERIND'
WHEN P.ETHNIC_GROUP IN ('6') THEN 'NON-HISPANIC/NOT-SPECIFIED'
when P.ETHNIC_GROUP is null then 'Not Provided'
ELSE 'OTHER' END) |
How to create: