1 of 1 people found this helpful
I hate to sound like that guy, but we really need to see sample data to help here. In short, you need to make sure it's all in your dataset (as in one row of data for each student, for each class). Then you can display what you need.
For something like this, it can be simplest to avoid funky calcs and:
- put two vizzes in a dashboard - viz 1 is the list of students and results for class A, viz 2 is all students and all their classes and grades
- use highlights or filter actions from viz 1 to viz 2 - whenever you select a student or class it shows the rest of their results in viz 2. Gives quite a usable/understandable interface for users and doesn't require loads of complex calcs
That's understandable. Ill have to see if Im able to make a sample generic enough that I would be able to post. Thanks.
Support gave me an good solution. In my excel file I duplicated the "Courses" worksheet which gave me two "Courses" tables to work with. I used one to filter which courses I wanted as the base of what they have taken, and I used the other to see how well they did in other classes.