7 Replies Latest reply on Jan 9, 2017 10:40 PM by Alec Chen

    Calculating time elapsed based on an account number or unique identifier

    Alec Chen

      Beginner here - title probably doesn't make much sense, but basically I have a Date, Transaction #, Customer Account #, Issue Amount, and Redemption Amount. So my data will look something like this:

       

      DateTransaction #Customer Account #
      Issue AmountRedemption Amount
      1/1/2017001ABCDEFG500
      1/5/2017002ABCDEFG050
      1/6/2017003ZYXWVUT1000
      1/6/2017004ZYXWVUT050
      1/7/2017005ZYXWVUT050

       

      From this data I want to find the average time between "Issue" and first "Redemption" but I am not sure how to go about it. Might just need to talk it out. Any ideas would be much appreciated!