Market Basket Analysis in Tableau

1
votes

I'm trying to do Market Basket Analysis in Tableau. In the image i attached, you will see a heat map (see image 1). For product 1 and product 2, the numbers of overlapping customers are shown in the heat map. enter image description here

My question is that if it is possible to do another heat map to show the non-overlapping customers? The attached heat map is created by joining the same table to itself.(see image 2), so the logic is to join on customer ID. If i want to show non-overlapping customers who are the real potential business opportunities, may be joining the same table to itself is not the right way to go any more...Can anybody share some insights here? Thanks! enter image description here

1
tableau-apimarket-basket-analysis

1 Answers

1
votes

First just a hint. I believe a heatmap is better visualized with colors, and not squares with varying sizes. So drag the CNT(Number of Records) to "Color", not "Size".

Now back to your question, I'm assuming you want the total number of orders with Product 1 that does not contain Product 2.

In that case, you need a table calculation:

TOTAL(SUM([Number of Records])) - SUM([Number of Records])

Then you need to adjust the table calculation so it gets to sum the row or the column.