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


      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!