4 Replies Latest reply on Sep 6, 2018 12:23 AM by Quentin MAROT

    Order Rank per customer and brand according to the date

    Quentin MAROT

      Hi Tableau Community,

       

      I'd like to calculate the rank of each orders per customer and brand, according to the order date. I found how to do that with table calculation, but I'd like to keep the result of this calculation in a dimension in the aim to do other calculations using these values. I've seen a lot of related topics, but all the time, the ranking was created regarding the Revenue, and not the date.

       

      Please consider I have a simple extract with the following fields: CustomerId, BrandId, OrderId, OrderDate

       

      The result I'm expecting is like that:

       

      CustomerIdBrandId
      OrderId
      OrderDate
      Rank
      AX

      1

      01/01/2015

      1

      AX202/01/20152
      AY303/01/20151
      BX404/01/20151
      BY505/01/20151
      BY606/01/20152

       

      How would you proceed for that please?

       

      Thanks in advance,

      Quentin