Inspired by Łukasz Majewski resurrection of the Educational Brain Teaser a few weeks back (check his out here Educational Brain Teaser - Custom Territories ...well worth taking a look)...I came across an interesting problem, which seemed a perfect fit for a Brain Teaser.
Attached is a packaged workbook (just blank with the data, and parameter you'll need; in 10.5), and also just the data (in Excel) if you can't open 10.5 files.
We have exam results for Maths and Physics, over 3 different exams (Exams 0, 1, and 2) for 9 Students. The Exam Numbers (0,1,2) are in the order the Exams were taken, and what we need to create is a Scatter Plot for Maths vs Physics Results for Exam number 0...simple so far!
Now on selection of a Student (identified by Student ID), via a parameter, we need their Exam 0 result highlighted by a black dot, and also show their other 2 results (Exams 1 and 2), with a line connecting them together.
Here is a GIF showing what the final viz should look like and how it should work.
There is no need to do anything to the data (...you can if you really can't work out a way with it in it's current form, but there is no need). As a bonus, without fixing the X and Y axis range manually, how did I get the Axis in the above GiF to not keep resizing, as different students are selected.
To me this problem encompasses 2 of the key themes I think about when working with Tableau.
For the impatient ones, here is the solution in the thread.
Please post your best attempts, comments, where you get stuck...etc. in the thread; There (as always) are a few ways to solve this problem, so will be interested to see how you all approach it!
I'll post a written up solution at the end of next week...Happy Vizzing!