Yes! This is exactly what I'm trying to do! I looked at the tableau file and still cant figure out how to add the third element. it does a walkthrough of the two element charts but that's it... the Sales by Regipn sheet has the 3 element waffle but I cant figure out whats going on w/o the data and it won't let me access the data source page (says the source is missing). Do you know if there is a way to message people in tableau public to get more information?
I was able to get to the underlying table and recreate the workbook.
Though we're not able to get to the datasource, you can see
what it was made of by clicking on "View Data" icon:
The file is a scaffold, and its just the sequence of Column numbers and Row numbers:
1|1, 1|2, ...1|10, 2|1, 2|2 ..., 10|10
This file is attached.
I think you've seen the posts describing how the data is being blended to the scaffold
even though there isn't a common key between them. Here, I will do my best to just
describe the steps that I took to get it to work.
The Regional Sales calculations are on the Data side and are straight from Ben's workbook:
SUM(IF [Region] = "Central" THEN [Sales] END)/SUM([Sales])
The Scaffold side has the calculation [Region Percentage]:
IF INDEX() <= [Sample - Superstore].[Sales South]*100 THEN "South"
ELSEIF INDEX() <= ([Sample - Superstore].[Sales South]+[Sample - Superstore].[Sales Central])*100 THEN "Central"
ELSEIF INDEX() <= ([Sample - Superstore].[Sales South]+[Sample - Superstore].[Sales Central]+[Sample - Superstore].[Sales East])*100 THEN "East"
ELSE "West" END
which is checking if the percentage is greater than or equal to the individual block's index,
and is offset by the percentage of the regions that came before.
It has very specific table calculation settings:
There is one other field on the Detail shelf which is the created by control-clicking on the both Columns and Rows
and the right-clicking > create > Combined Field which gives every combination of column and row.
It looks like the labels were done by Annotations.