3 Replies Latest reply on Apr 22, 2018 3:13 PM by Shinichiro Murakami

    Average time difference between transactions




      Link to related question..



      Trying to determine how to average time difference between transactions..


      - single transaction (processed) triggers start of transaction with a time stamp.

      - Receivers can generate multiple transactions (open) with timestamps from processed timestamp.


      Can determine the min & max time to open, However the average time to open for these events I can't figure out???


      Attached is a small sample of single email transaction, I am looking to aggregate this for larger volumes of receivers and email ids across broad time frames.


      appreciate any assistance