I've attached a sample graph. I'm measuring pass rate (%). Each color in this bar graph represents an academic department (for example, biology, english, chemistry, math, physics), and each bar itself represents a course within each department. I would like to display the top 5 courses within each department for any given semester. And I'd like to display all available departments (let's say I have 8 total departments). For illustration purposes I had to use filters to get this displayed as you see it, but I don't want to use filters because the values can vary greatly from semester to semester. I.e., if I set the minimum % rate at 35%, next semester the rates may be much lower, and I wouldn't pick those up. For any semester, for example, I just want the top 5 courses in terms of percent to display for all available departments.
... View more