15 Replies Latest reply: Mar 29, 2017 5:22 AM by Sunny Talwar RSS

    Market Basket-find associate items not on same orders but on same session

    Sara Siu

      Help!!

      I have the sample data like below, I want to do a basket analysis, e.g. when I select an category on an list box(e.g. DL) the graph would show the associate category that is in the same session id, but without invoice id (in terms of no. of time of session)

       

      Session IDInvoiceIDItemIDCategory
      36201211

      DL

      36201212DL
      36201213DB
      36201214DB
      36201215W
      3620216Q
      3620217Q
      3620218E
      11112219DL
      11112220E
      11112221JL
      1111222JL
      1111223Q
      1111224W

       

       

      for example, when I select DL on a list box,The result should be below, how can I achieve below  with what dimension and expression??? Many Thanks for help.

       

      CategoryNo. of session
      Q2
      E1
      W

      1