A better way to visualize Venn Diagrams
The UpSet Plot
UpSet plots are a data visualization method for showing set data with more than three intersecting sets. UpSet shows intersections in a matrix, with the rows of the matrix corresponding to the sets, and the columns to the intersections between these sets (or vice versa). The size of the sets and of the intersections are shown as bar charts.
In this #WOW challenge, watch me as I build this upset plot in Tableau.
Play Video
The calculations
The only calculation we need is a concatenated list to evaluate if each subcategory exists within a Customer Name partition. I’ll use an LOD
//Subcat Set
{ FIXED [Customer Name]:max(if [Sub-Category]="Bookcases" then "B" else "0" end)}
+" | "+
{ FIXED [Customer Name]:max(if [Sub-Category]="Chairs" then "C" else "0" end)}
+" | "+
{ FIXED [Customer Name]:max(if [Sub-Category]="Furnishings" then "F" else "0" end)}
+" | "+
{ FIXED [Customer Name]:max(if [Sub-Category]="Tables" then "T" else "0" end)}GO FORTH AND VIZ!
Check out the interactive visualization below
