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

    Average time difference between transactions

    neil.larkin

      Hi,

       

      Link to related question..

      https://community.tableau.com/thread/268106

       

      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