3 Replies Latest reply on Nov 23, 2018 4:39 AM by Ankit Bansal

    Customers buying product X also bought these other products

    Cerys Heath

      I have a large dataset that is structured like this (example taken from the Superstore sample data):

       

      Customer IDProduct type
      Purchase date
      AStorage18/02/2014
      AArt07/03/2014
      ABinders07/03/2014
      AArt10/11/2016
      BBinders22/04/2014
      BStorage22/04/2014
      CPaper27/07/2014
      DStorage28/03/2014
      DBinders02/01/2017

       

      I want to find out, for each product, what other products are popular among that customer group. So if I filter for product type and date it will look at customers who have bought that product type in that time period. and then show me the other product types those customers have bought, and a count of how many for each product type.

       

      So in the above dataset, if I filter for Storage, it should show me

      Binders - 3

      Art - 1

       

      Because A, B and D bought Binders, and A has bought Art (I'd like this to only count as 1, even though A has bought Art twice).

       

      Is something like this possible? How might I go about it?