This week I'm testing your knowledge of building common baseline charts in Tableau. These charts are really useful for aligning metrics that start at different time periods. I'm using some data from one of my favourite sports - American Football. With the Super Bowl looming I wanted to compare Quarterback passing yards over all the seasons they've played. This chart is perfect for this because no matter which year the player started, I can compare them all from a common baseline.
Your job is to re-create this viz like-for-like. You can download the data here - I got it from www.nfl.com.
Here's some pointers to keep in mind:
- You will have to use a Union in Tableau to get the data in to 1 table
- I pivoted the data to get it in to an easier to use format
- I filtered the quarterbacks to those that have played at least 3 season and those that have passed for at least 2000 yards in total
- You should be able to pick the QB that you want to highlight - this should be only the list of QBs after the filter
- The highlighted QB should be shown in the light blue colour and should have a circle at the end of the line displaying their total passing yards
- Make the formatting of the chart the same as mine
Post an image on Twitter when you’re done and hashtag it with #WorkoutWednesday and please tag me and Andy so we see it (@EmmaWhyte and @VizWizBI). Good luck!
Interesting, I think your filter isn't right. I added a data source filter on Player with the following condition.
ReplyDeleteCOUNTD([Year])>=3 AND
SUM([Yds])>=2000
This removes the overall, whereas your filter is removing individual seasons. So my filter ensures every season for Kirk Cousins is included, whereas your's only includes seasons when he threw for 2000+ yards so his cumulative total is wrong. Which was your intent?
I made the assumption that you intended to filter the way I've done it, so I think I got it all correct. Post on my blog http://www.vizwiz.com/2017/01/workout-wednesday-cumulative-passing.html. Thanks Emma!!
DeleteHi Andy - yep you're right and I've updated my filter to be correct now! Thanks.
Deletesorry bit late... But I replicated after bit of effort. Very good initiative keep it up Emma and Andy.
ReplyDeletehttps://public.tableau.com/profile/arshad.malik#!/vizhome/WorkoutWednesday-NFLQB/NFLQB
Hi Emma,
ReplyDeleteI did the workout, it looks like yours, but I don't know why the highlighted QB line is behind the other lines ...
I used different line size and color for selected QB, but still the issue.
https://public.tableau.com/views/Wrokoutwednesday-CommonBaselineChartsAndNFLQBS/Dashboard1?:embed=y&:display_count=yes
Thanks
Hi Mourad. I can't download your workbook from Tableau Public (you usually have to change the permissions), but you should be able to apply a sort on your QBs based on the highlighted true/false calculation.
Delete