Predictions vs. Actuals in a Waffle Chart
May 20, 2018Klaus Schulte
For this week’s #MakeoverMonday I created a visualization to compare Premier League pre season predictions with reality after 38 rounds:
I was inspired by an article in our local newspaper some weeks ago where possible changes at the last matchday in German Bundesliga were visualized this way:
I like this viz by muensterlandzeitung. pic.twitter.com/kl77cQscLD
— Klaus Schulte (@ProfDrKSchulte) 10. Mai 2018
I recreated the basic idea of this viz by using a waffle chart.
If you want to recreate my viz it just needs the following few steps.
1. Create a waffle
To build the waffle I created this data in Excel combining twenty rows (“Zeile”) with twenty columns (“Spalte”) to get the 400 cells of my matrix.
Bringing in “Zeile” on rows and “Spalte” on columns, selecting square in the marks card and a little bit of sizing the squares creates this waffle in Tableau.
2. Linking waffle and data
After linking my two data sources on “Zeile” and “Actual Finish” I was able to bring in the teams on rows.
3. Coloring the waffle
To color the waffle it just needs two boolean calculations:
a) [Spalte]=[Zeile] for the actual finish (the diagonal) and
b) The difference between actual and predicted finish
The rest is just a little bit of formatting.
Thank you for sharing, I really liked your visualisation. I am a beginner at Tableau, and I am just stuck on the 2nd point. How did you link the data to the waffle chart on “Zeile” and “Actual Finish”? When I try to blend my data by creating a link between these two fields, I can’t incorporate “Teams” to the sheet as there is no relationship between Teams and the Waffle Chart.
Just added two screenshots in the blogpost. In your English version you have to select Data > Edit Relationships.
Ok, got it! Thank you😊
Thanks Lindsay! Looking forward to see the results 😀
Great post! I may have to try this. 🙂 Thanks for sharing.