Hi Folks,
I am attempting to create a histogram(http://community.qlik.com/blogs/qlikviewdesignblog/2014/08/13/recipe-for-a-histogram) where I show a distribution of test scores. Because our team needs to be able to do a question level analysis in a separate part of the dashboard, each row in the table is distinct by each question and student pairing (both separate columns), not by each student. We have a column for the total score for each student, but this is repeated in each row.
Example:
| Studentid | Question# | TotalScore |
|---|
| 1 | 1 | 50% |
| 1 | 2 | 50% |
| 1 | 3 | 50% |
| 2 | 1 | 70% |
| 2 | 2 | 70% |
Is there a way in the expression to filter for the distinct student ids, so that the histogram only aggregates the total scores once?
Currently my dimension is:
=round(TotalScore,[Bin Width])
Expression:
count(TotalScore)
Thanks in advance,
Briana
