Author avatar

Recnac

Tableau Playbook - Individual Waffle Chart

Recnac

  • Sep 4, 2019
  • 7 Min read
  • 93 Views
  • Sep 4, 2019
  • 7 Min read
  • 93 Views
Data
Tableau

Introduction

This is the second part of a two-part series on Tableau Playbook - Waffle Chart. In the first part, we delved into the concept and how to build an all-in-one waffle chart. Check it out in case you missed it.

In this guide (Part 2), by analyzing a real-life dataset, Worldwide Smartphone Sales, we will practice creating an individual waffle chart step by step. Meanwhile, we will draw some conclusions from Tableau visualization.

Example

Here is an individual waffle chart example from Gwendoline Tan. This example uses a group of grid plots with the waffle shape to compare the five-year survival rates of reproductive cancers. With the help of grids, the waffle chart provides a more accurate and clear comparison than the pie chart.

example chart - individual waffle chart

Individual Waffle Chart

This time we will build another common form of the waffle chart - individual waffle chart. We are going to use a dashboard to combine individual waffles.

  1. First, we duplicate the all-in-one waffle chart and reform it.

    1. Keep the step 1-4 and 6 of the previous process. Remove the original color marker "AGG(Mobile OS Color)".
    2. In order to merge into a dashboard, we need to shrink it. Drag the bottom and right axis to a smaller size.
    3. To make all of the sheets share the same filters, we right-click on "QUARTER(Date)" and choose Apply to Worksheets -> All Using This Data Source.

    individual waffle chart - process 1

  1. Display only one category in each waffle chart.

    1. First, we need to create calculated fields for that. Taking "Android Color" as an example, we input formula as:

      1
      [Sheet1 (market_share_of_mobile_os)].[Android Ratio] >= AVG([Percentage])
    2. Drag "Android Color" into Marks - Color.

    3. Edit Colors to highlight this category. Change the color of "False" to light gray and "True" to a unique color.

  1. Add well-formatted percentage labels to make quantitative comparisons easier:

    individual waffle chart - process 2

    1. Switch to Data Source "market_share_of_mobile_os".
    2. Drag "Android Ratio" into Marks - Details.
    3. Format "AGG(Android Ratio)" as Percentage and set Decimal places to 1.
    4. Right-click on the central grid and click Annotate -> Mark...
    5. Edit Annotation in the pop-up dialog. Insert the above parameter "AGG(Android Ratio)" and match the cell color. Set the Font size to 22 and Bold.
    6. Right-click on this annotation and click Format...: set the Shading and Line as None.
    7. Edit and centered title as the name of mobile OS.
  1. Create the rest of the five waffle charts in a similar way.
  1. Combine these six sheets into a dashboard. There's a lot of fine-tuning work in it, but we are not going to expand here.

    Only mention the trick to create a dynamic dashboard title. According to this thread from Tableau, we can add a blank worksheet and have that appear to be the dashboard title instead.

The final rendering is as follows:

individual waffle chart - final

If you prefer individual shape for each waffle, you can use Shape mark type. The following dashboard shows an example with Filled shapes:

individual waffle chart with shape - final

Analysis:

For this individual waffle chart, we can focus on the market share of a particular mobile OS as well as compare all categories horizontally. Moreover, we can observe the distribution of various time points by using the Tableau interactive legend.

To help audiences distinguish, we keep colors consistent in the chart, label, and title.

Conclusion

In this guide, we have learned how to build an individual waffle chart. First, we duplicate and reform a waffle chart. Then we combine six waffle charts into a dashboard. In the end, we do some fine-tuning work on the dashboard.

You can download this example workbook Waffle Chart from Tableau Public.

In conclusion, I have drawn a mind map to help you organize and review the knowledge in this guide.

individual waffle chart - mind map

I hope you enjoyed it. If you have any questions, you're welcome to contact me [email protected]

More Information

If you want to dive deeper into the topic or learn more comprehensively, there are many professional Tableau Training Classes on Pluralsight, such as Tableau Desktop Playbook: Building Common Chart Types.

I made a complete list of my common Tableau charts serial guides, in case you are interested:

0