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.
0 kommentar(er)
