Resolved: Class Schedule > Crosstab Table % of Column metric problem

Updated 2/12/2025: 
The Class Schedule dashboard in Campus Data Warehouse production has been updated and now reflects the fix for the "% of Total Enrollment" column on the Multilevel Crosstab Table.

Uploaded Image
 

Original issue: 
The Campus Data Warehouse team is aware of a problem with the Class Schedule > Multilevel Crosstab Table dashboard page in production. The "% of Column" metric column is currently calculated as a percentage of the whole table (across terms) rather than a percentage of the column (i.e., Academic Year/Term). We are currently working on a solution. 

This issue is being worked on in ITSR# 23896916. Date reported: Thu 1/16/25 12:19 PM Pacific Standard Time

 
Ticket: 23896916 
Service: Report a Problem / Computer Software/Application Problem
Date created: Thu 1/16/25 12:17 PM Pacific Standard Time

Title: Class Schedule > Crosstab Table % of Column metric problem

On the Class Schedule > Multilevel Crosstab Table, the "Select Metric for % of Column" calculation used on the dashboard is wrong. It only works correctly if one year/term is selected. If more than one term is selected, it does a % of that metric for the whole table, which is not intended behavior and does not align with the functionality in our legacy (OBIEE) dashboard.

Uploaded Image
Should be QS changes (dataset & analysis) only.

Requested by: Michael Dorsch
Created by: Michael Dorsch on Thu 1/16/25 12:17 PM Pacific Standard Time