3 Replies Latest reply on Oct 12, 2016 4:28 AM by Hima vardhan Reddy Pavuluri

    Level of detail - finding next date

    Andrew Zabiela

      I have a list of customer transactions that includes a unique identifier for the customer and a date for each of their transactions.  I'm able to use the level of detail calculation to define the minimum and maximum transaction date for each customer (and this is applied to each row when I look at the data).  What I would like to do is for each customer transaction: show what the date is of the very next transaction for that customer (rather than the minimum or maximum).

       

      My goal is for each customer transaction understand when the next transaction was and how many days apart these were.