2 Replies Latest reply on Nov 18, 2013 9:47 AM by Carol Vazirani

    How to calculate arrival rate

    Carol Vazirani

      I have a set of transactions with date and timestamp fields.

      I wish to calculate arrival rate (no. of transactions per minute) for each hour.

      What I have is a calculated field:

      TRAN_COUNT = COUNTD(Order_key);

       

      How do I specify an aggregate calculation: Number of minutes =  MINUTES(Max(timestamp) - Min(Timestamp)

      so I can then have ARRIVAL_RATE = TRAN_COUNT / NUM_MINUTES