2 Replies Latest reply on Nov 7, 2016 9:03 PM by Brett Allen

    How do I count those who bought Product A on first order and Product B on next order (and so on)

    Brett Allen

      This might not be something I can resolve with Tableau.

       

      I have a dataset that looks like (sample attached):

      • Order / Customer / Date (booking date) / Brand

       

      What I need to discover is:

       

      1. The COUNTD customers who ordered PRODUCTA on their first order (Determine customers first order by date & product);
      2. which PRODUCT(X) did they order on the SECOND ORDER (then third, forth etc)

       

      Those who purchased Tomatoes on first order:

      • Order Tomatoes Again = X
      • Apples = X
      • Beetroot = X
      • Carrots = X
      • Didn't Order Again = 40
        • 1. Re: How do I count those who bought Product A on first order and Product B on next order (and so on)
          Łukasz Majewski

          Hi,

           

          This one is difficult to achieve but I think I produced the right values although the aesthetic result is not quite good. That is because I was not able to hide redundant marks without affecting data densification which would result in wrong results. So I switched off marks stacking but depending on the number of matching combinations they are layered on one another giving this ugly look as though they were not positioned precisely well.

           

          The columns show what the first product is and the rows hold the consecutive product purchased. The [First Product] and [Not First Product] are LoD calculations and are then used as dimensions in cross table so I hid the row & column where these yield NULL (as we are not interested in such combinations).

           

          This is what it look like for all the customers on their 4th order:

           

          and here is a selection of customers:

           

          As you can see the diagonal shows consecutive orders of the same product as the first one so you probably want to ignore those and I could not hide them for the aforementioned reason. I am not entirely sure if the values are right as I only checked a very few situations.

          1 of 1 people found this helpful
          • 2. Re: How do I count those who bought Product A on first order and Product B on next order (and so on)
            Brett Allen

            I think it is very close. We have decided to send this off as part of a bigger piece of work with some true data nerds. Really appreciate the effort in your response.