Launch, grow, and unlock your career in data

September 13, 2017

Workout Wednesday: Killings of Blacks by Whites Are Far More Likely to Be Ruled 'Justifiable'

No comments
A few weeks ago on my Data Viz Done Right website, I highlighted a great viz from The Upshot that I thought was an exceptional design and told a great story. I like to use vizzes like this for inspiration to see how tough they are to build in Tableau. So that's your challenge for this week. Yes, it's waffle charts again, but I had this post ready to go before Emma stole my thunder in week 34.


  1. Dashboard size is 750x2350.
  2. Make sure you credit the data source and credit The Upshot for inspiration as I have.
  3. Match my title.
  4. For each city, there should be two waffle charts. The first should show the overall percentage of justified killings. The second waffle chart should show the percentage justified when a white person killed a black.
  5. Match the text under each waffle chart. Note that the text must be in the same worksheet and the percentage displayed must be based on a calculation.
  6. The text above each pair of charts should span across the two waffle charts for that city.
  7. There should be a 20 pixel buffer between each row of charts.
  8. There should be a 20 pixel buffer between cities that are on the same row.
  9. Use hex code #CC0000 to represent the percentage justified and use #ECECEC to represent the unjustified killings.
  10. Match the layout exactly for the text boxes.
  11. Match the tooltips.
  12. Everything MUST be tiled; no floating elements allowed.
  13. I used the Benton Sans font, but that won't render on Tableau Public, so use whatever font you wish. Benton Sans helped me get the word wrapping and spacing just like The Upshot had it.

Data sources:

  • Get the waffle chart template here
  • Get the data for the killings here

By the end of this exercise, you should be much more familiar with layout containers. Personally, I love containers because I know how to manipulate them well. Hopefully you'll feel the same by the end.

Make sure you tag @VizWizBI, @EmmaWhyte and @TheUpshot (for their inspiration) when you tweet your final work. Also include a link to your dashboard.

Lastly, this is not particularly difficult, there are no crazy calculations, it's more a tedious exercise. Have fun! 

No comments

Post a Comment