1 of 1 people found this helpful
To clarify your question, you are wanting to compare GPAs using at least 4 different filters?
If possible, sample data always helps, but it seems to me that all you have to do is create 4 different worksheets with local filters and put them in a dashboard. Then you can set a global filter to change which course you are viewing on the dashboard. Just make sure that the bar graphs are formatted correctly and are uniform 0-4.0 marked every .5 GPA. Will that solve your situation or am I not understanding the question?
It sounds like you are following what I was trying to do. I should have posted a little excel spreadsheet to help out.
If I understand correctly, that is the direction I was going, but I thought it started to get a little tricky to use and didn't look as good spread across the four different charts.
Thanks for the quick response.
Thanks for the very thorough and quick response. It does help quite a bit. I'll have to look into those table calculations to see what they do, but it looks to be almost exactly what I want.
The one thing I did notice, though, is that the GPA for the department always matches the course GPA. For instance, selecting course C or D, I think, should show a Department gpa of 3.4 (instead of 3.2 for C and 3.6 for D).
What I ended up doing (I guess I should have thought of this quicker), was just adding some new data sources that are custom sql queries. I added one data source for Department GPA that was just the average gpa grouped by department, one for College GPA that was the average gpa grouped by College, and the same idea for University.
This made the workbook pretty straight forward and probably the direction I'll work toward until I can figure out how table calculations work (maybe it's easy?).
Thanks again for the help.
1 of 1 people found this helpful
Shaun: I've been trying to wrap my head around similar problems/calculations, so I jumped in and was exploring Tracy's response. I was able to match Sheet one by editing the GPA by departments Table Calculation to "advanced", compute using the four fields in order, at the level of "Course" and restarting every "Department". I'm not sure how this fits into Tracy's approach, but if you can wrap your head around the table calcs, it seems would be a cleaner way to attack the problem instead of separate datasources.
Thanks for the follow up. I followed your instructions and was also able to get Tracy's worksheet to work like I expected. One funny thing is that when I was looking at it yesterday I didn't even notice there were two worksheets.
I think you are right... I'm going to read about table calculations and try to follow this same pattern for my project.
Thanks for the help.
Your solution to Shaun's problem is close to answering a problem I've been wrestling with about course evaluations as well, and I was hoping you might be able to help me structure my data appropriately to produce the below table:
Where you have a University-College-Department-Course hierarchy in Sheet 1, I need to display results for each course taught by an instructor compared to the department aggregate compared to the college aggregate, as pictured. We've been producing these tables in Excel, and I want to move us away from that and into Tableau reporting. Essentially, each instructor receives a summary sheet displaying their personal course evaluation results (e.g. Course 1 and Course 2) with department and college overall aggregates for comparison purposes; I can easily make the course-dept-college distinctions in Excel, but am stuck on how to achieve this in Tableau.
Your help would be much appreciated!