7 Replies Latest reply on Aug 21, 2018 2:12 PM by Jim Dehner

    Finding the Difference in days between orders by customer

    Xander Spears

      Hi Community,

       

      I have tried everything. From using ranks to lookups to levels of details and I am at a loss.

       

      I am trying to find the number of days difference between orders at a customer by customer level.

       

      The data is structure as so..

       

      CustomerOrder NumberOrder Date
      Days from previous order

      X

      12344/9/2018This is what I am trying to calculate
      21454/20/2018*Calculation should read 11* etc
      26545/16/2018
      35896/22/2018
      12566/25/2018
      Y23545/4/2018
      78545/20/2018
      69875/28/2018
      35746/5/2018

       

       

      If anyone has any idea as to how to solve this please let me know. I am not able to share the exact data but my goal is to classify the time between each order and eventually put that number into buckets for further analysis. I have come across countless obstacles to finding this seemingly simple solution so any help is welcome,

       

      Thanks.