Forum Discussion
Totals
You need to unpivot the data in the query editor so it has the following columns
student name, class name, value
when you have these three columns, you can just drag the columns Into your report and get the total column (put value column in the values section). Then write some measures such as
classes completed = sum(table[value])
total students = distinctcount(table[student name])
0 class = divide(sumx(values(table[student name]),[classes completed]=0),[total students])
repeat for 1,2 etc
You need to unpivot the data in the query editor so it has the following columns
student name, class name, value
when you have these three columns, you can just drag the columns Into your report and get the total column (put value column in the values section). Then write some measures such as
classes completed = sum(table[value])
total students = distinctcount(table[student name])
0 class = divide(sumx(values(table[student name]),[classes completed]=0),[total students])
repeat for 1,2 etc