Dec
28
Creating Waffle Chart Multiples in Tableau
In a previous article, we showed how to create waffle chart from a single percentage, without extra data table and without table join. Also the labeling is automated instead of manual, comparing to other approaches.
Now we are going to apply the same method to creating waffle chart for multiple percentages as follows. Note that the percentages are calculated horizontally, showing the percentages in different regions per each category.
The steps are: (The 2nd step uses a different approach from the previous one for the same result.)
1.Union the data source with itself.
This will generate a new column Table Name with two different table names.
2.Use the two table names to define the first and 100th points
For each waffle chart, we need to have a 10x10 grid of 100 data points.
Now we are going to apply the same method to creating waffle chart for multiple percentages as follows. Note that the percentages are calculated horizontally, showing the percentages in different regions per each category.
The steps are: (The 2nd step uses a different approach from the previous one for the same result.)
1.Union the data source with itself.
This will generate a new column Table Name with two different table names.
2.Use the two table names to define the first and 100th points
For each waffle chart, we need to have a 10x10 grid of 100 data points.