2 Replies Latest reply: Oct 14, 2015 3:36 PM by Sunny Talwar RSS

    How do I get average of interval in minutes

      I tried a number of things, with no luck.

      In the expression, I have:

       

      Interval(Date(Date#(FirstCallDate,'DD/MM/YYYY hh:mm:ss'),'mm') - Date(Date#(CreateDate,'MM/DD/YYYY hh:mm:ss TT'),'mm') ,'mm')

       

      It works fine if I just have 1 record (1 FirstCallDate, and 1 CreateDate).

       

      But, I want an average of no. of records. (Average of interval in minutes)

       

      I tried :

       

      AVG(Interval(Date(Date#(FirstCallDate,'DD/MM/YYYY hh:mm:ss'),'mm') - Date(Date#(CreateDate,'MM/DD/YYYY hh:mm:ss TT'),'mm') ,'mm'))

       

      No luck. Any suggestions?