Creating Waffle Chart from a Single Percentage in Tableau

Waffle chart is popular for visualizing a single percentage. How can we create such a chart?

Here are the steps. The example data source has a single data record.

1.Union the data source with itself.
Thus the data source has two records now. And it generates a new column: Table Name

2.Define the first and 100th points
Based on the two table names, we can define the two points. We need to have 100 points to create a waffle chart, as a 10x10 grid.

3.Create Point Bins from 1 to 100
Thus we define the 100 points. Bin size = 1
The bins will allow us to create a 10x10 grid that is the essence of the Waffle chart.

4.Create X and Y coordinates for the 10x10 Grid

• X = -First()%10
• Y = Int(-First()/10)

Both compute along Point Bin. BTW -First()=Index()-1.

5.Populate Percent to every point in the grid.
Percent Omni = Window_Max(Max(Percent))
We have only two real data records as data points. The other 98 points are results of data densification. We need table calculation to assign data to them.

6.Color the grid
Use this formula Index()/100<= Percent Omni 
Index()/100 will assign a percentage to each point from 1% to 100%.

7.Label the grid
We only need one label in the middle. Then
If Index()=55 Then Percent Omni End

That is it. You can watch the video for further details.

The workbook can be downloaded here.