10 Replies Latest reply on Oct 25, 2016 12:30 AM by Łukasz Majewski

    Can anyone help me to explain the Market basket Analysis?

    Bowen CAI

      Currently I am using a self-joining method to create a market basket analysis in Tableau. But I have a little bit difficult to interpret the results. For example, one result shows "Sub_category: A ; Sub_category: B; Number of records: 2000". How this 2000 is calculated?

       

      I created a sample worksheet below.

       

      Order_product_idorder_idcustomer_idsub_category
      111A
      221A
      321B
      421C
      531A
      631B
      742A
      852B
      962C
      1062B
      1162A
      1273D
      1373C
      1484E
      1595E
      1695F
      1795B
      18106E
      19106F
      20117B
      21128B
      22139C
      231410A
      241410B
      251510C

      Based on the data above, we know the AB pairs occurs 4 times, but why in the Tableau, when it calculates, the number of records shows 11? Screen Shot 2016-10-24 at 11.15.08 AM.png

       

      Can anyone help me to clarify my doubt? Thanks.

       

      Warmest regards,

      Bowen