Other Cosmetics: Adjust the size of your squares, Drop grid and zero lines.Add to Detail and set the measure to Average.Edit colors: True sqares with Gray while all others are colored to your choice (.Now we have 2 combined measures on color. Then right click the icon on the left and change it to Color. Add the boolean calculated field to Detail,.

Drag and drop it infront of as a discrete dimension.

Drag to the rows shelf and to the columns shelf.

Let’s create a calculated field to check that out – we would like to distinguish between grid records that are higher or equal to survival rate (measured percentage).ĪVG() <= AVG() has a boolean (True/False) result and shows us exactly what we need. All we have to do is color the right ones! Algeria’s records of cancer type and year Waffle Template (First 20 Rows)Ĭross joining is acomplished simply by an inner join based on the condition 1 = 1 as seen in the image below.Īfter cross joining the template, we now have 100 records per initial original record, from 1 to 100 (10 x 10 percentage Grid). After cross joining Algeria’s data with the full Waffle template, we are expecting 3000 records instead of the current 30 (30 * 100). Our purpose is to multiply each record with each record of the template (aka Cartesian product of rows). Below, we can see Algeria’s records of cancer type and year. Cross – JoinĪ cross join will combine each row from the first table with each row from the second table. The data summarizes 5 year survival rates in 1999-2009 for different cancer types across the world. The cross join will densify the data – creating 100 records for each initial record.įor the purpose of this viz, we will use data about cancer taken from ‘Our World in Data’, a great site hosting research and data on global problems and global changes. Data densification will be done by cross joining the template with the data. The full template will be used to densify the initial data we want to visualise. Rows, Columns and Percentages should be continued in the same manner up to 100 percent.

As you you might have figured out, we are creating a 10X10 layout of percentages of 100%. Below, We can see a part of the template. Making waffle charts is maybe a little bit tedious, but fairly simple!įor the purpose of waffle charts we will use a template to help us with the task.

The waffle lab download