Hi everyone, I’m looking for some help with a Tableau dashboard I’m building. I’ve attached screenshots of my current worksheets and the dashboard layout.
I have
multiple athletes displayed on the same dashboard, and each athlete has their own position filter. For example, Athlete 1 could be benchmarked as a GS while Athlete 2 could be benchmarked as a GA.
For each statistic, I want the athlete’s
AVG/Q to automatically colour:- 🟢 Green = above their selected position’s League Avg/Q
- 🟡 Yellow = equal to the League Avg/Q
- 🔴 Red = below the League Avg/Q
The main issue is that the athlete AVG/Q and League Avg/Q are on separate worksheets. I need the position selection to change the League Avg/Q benchmark, but I don’t want it to filter the athlete’s own statistics, as their AVG/Q should remain their total for the match.
I also need each athlete’s position selection to work
independently. Changing Athlete 1 from GS to GA, for example, shouldn’t change the benchmark selected for Athlete 2.I need this to work across multiple stats such as CPR/Q, Feeds/Q, Assists/Q, Gains/Q, etc.
What would be the best way to set this up in Tableau so the conditional colouring works correctly?
Thanks for any help!
#Tableau Desktop & Web Authoring
I would suggest that you attach your packaged workbook (twbx) so that any solution suggested is relevant and works for you.
