VizWiz

Launch, grow, and unlock your career in data
Showing posts with label waffle chart. Show all posts

December 17, 2024

, , , , , No comments

Learn how to build a stunning waffle chart in Tableau using map layers and calculations! 

This advanced Tableau tutorial will show you how to simplify the creation of waffle charts while unlocking powerful design and flexibility for your data analysis projects.

You’ll Learn How To:

- Connect Tableau to Superstore and a waffle chart template with Relationships

- Use the MakePoint function to create dynamic map-based charts

- Apply map layers for advanced customization and perfect label placement

Why You Need This:

This method combines advanced Tableau charts with the flexibility of map layers, allowing you to:

1. Create precise grid-based waffle charts.

2. Perfectly center labels without complex workarounds.

 Who Is This For?

- Data analysts looking to enhance their Tableau dashboards

- Advanced Tableau users exploring new chart techniques

🔗 Workbook  |  Data

Become a Next-Level Tableau member and become a Tableau expert


September 10, 2019

#TableauTipTuesday: How to Create a Waffle Chart Using Data Densification

, , , No comments
In this tip, I show you how to use a calculated join to create a waffle chart. This method of data densification can remove the need for any complex data blending.

August 6, 2018

Makeover Monday: America's Contribution to Worldwide Research & Development Steadily Declined From 2011 to 2015

, , , , , , , , , No comments
Back to London and back to work this week after a wonderful holiday in Scotland. This week, Eva is asking us to makeover this visualization from HowMuch.net.


What works well?

  • The title is clear, making the topic easily known.
  • The big numbers work well for the larger circles.
  • It's an innovative design, but that doesn't mean it effective.
  • Citing the sources

What could be improved?

  • Pretty much everything
  • The sequence is too hard to understand.
  • The color legend is sorted descending.
  • The colors on the ends are too similar.
  • There's way too much text, making it all feel very squished.
  • The color ranges aren't of equivalent size.
  • The maps of each country inside the circles don't add any value.
  • It would take forever to find out where a country ranked.

My Goals

  • Throw away everything they did and start over.
  • I really liked the simplicity of Eva's viz, so I went with her idea of focusing on just the US.
  • I wanted to understand how the contribution the US has made has changed over time.
  • Use the official Makeover Monday color palette


March 14, 2018

Workout Wednesday: Candy Button Small Multiples

, , , , , , , No comments
Rody brought back a classic technique for Workout Wednesday week 11. Get all of the requirements here. Almost exactly two years ago, he wrote a guest post on this blog about how to create the unit charts he's challenging everyone to make.

One thing he mentioned in the blog is that now you can use unicode characters in 10.5, however, I've been using them for a long time. I got to this site, find the character I want to use, and paste it into the calculation or field name.

The trickiest part for me on this challenge was getting the dots in the right place, that is, starting at the bottom right. I had to swap some of the logic of the calcs around and it was done. As for the headers above each set of dots, well, I'll leave that to you to figure out. Here's my tip: don't overcomplicate it; it's quite simple.

Again, find all of Rody's requirements here. Click the image below for the interactive version.

November 27, 2017

Makeover Monday: Two Simple Ways to Improve the World

, 2 comments
Today marks week 100 of #MakeoverMonday, the Community project. Sometimes I sit back and pinch myself at what it's become. Other times, I stand up and think about what more we could do. Without all of you, this project wouldn't be what it is today. Thank you!

To celebrate week 100, Eva and I will be hosting a webinar next Monday and we'll be joined by Andy Cotgreave (yes I know it's week 101). Register here. In this webinar we'll reflect on the first 100 weeks and answer any questions you have. It's going to be fun!

In addition, we have two more webinars coming up this week. You can find all of our webinars here.


This week, Eva picked something relating to 100. 


What works well?

  • It's quite attention grabbing due to the overall design and color.
  • The big text in the middle catches your eye.
  • Every section is clearly labeled.
  • Underlining each slice with the color it represents.

What could be improved?

  • There's no overall structure or order.
  • At first glance it looks like a donut chart, but each section adds up to 100 by itself.
  • The grey background behind each section label is unnecessary.
  • Within each section, the segments should be ordered by size.

My design this week is heavily influenced by Eva and Charlie Hutcheson. Both of them made very simple visuals that are quite stunning and stop you in your tracks and make you think. So how could I do something similar? Well, here it goes...

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.

Requirements:

  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! 

August 23, 2017

Workout Wednesday: The Waffles of Disney's Domination

, , , , 2 comments
Oh Emma! She thought she could trick me today. Mind games I say! Today's workout is to create waffle charts. Read all of the details here.

The waffle chart bit was pretty straight forward. The trickiest part for me was the calculation to get the % of total.

Fun one! Give it a go!

March 27, 2017

Makeover Monday: The Secret of Success

, , , , , , 8 comments
For Makeover Monday week 13, we looked at a visualisation that I found on Visual.ly that I use in the Data School's first data viz training class where we look at critically evaluating visualisations.


Andy Cotgreave messaged Eva and me about this particular viz and found a great article that does an excellent in-depth review of this particular piece. Reading the article helped reassure the thoughts that I've had about this chart over the years.

What works well?
  • Engaging design
  • Clear labels on the values
  • Legend matches the shape of each amoeba
  • Everything is scaled in proportion
  • Good color choices
  • Nice big title

What doesn't work well?
  • The subtitle is very offensive. It sure seems this survey was conducted by some extreme right-wing group.
  • The overlapping colors make it hard to follow the pattern.
  • Radar charts are very hard for making comparisons across categories.
  • The radars are curved to make the segments appear to take up more space.
  • Unnecessary icons

I wanted to be able to compare all of the segments in one view, meaning both across social strata and across reasons. I did a quick bit of google image searching to get some ideas for survey visualisations to help gather my thoughts.

In the end, I went with a simple small multiple, waffle chart type design (mind you they are circles instead of squares). I chose to highlight the largest response rate for each social strata and call out in the title the key findings.

Click on the image for the interactive version.

January 17, 2017

Tableau Tip Tuesday: How to Create Waffle Charts

, , , 9 comments

I love waffles! So why not learn how to make waffle charts? This week, I show you a very simple way to create them. Inspiration for this post came from this post by Russell Christopher. The difference between his post and mine is that I don’t require any table calculations; that’s nearly always a win for me!

I created a template for the grid layout (the primary data source that I use in the video), which you can find here. I’d love to see more examples that you build with this. Good luck!

Subscribe to: Posts ( Atom )