4 Replies Latest reply: Mar 12, 2012 8:37 AM by Arjan IJlenhave RSS

    Second connection

    Arjan IJlenhave

      Hi all,

       

      I'm making a dashboard on a telephone database. One of the KPI's is the time between throughconnect and answering.

      I give an example:

       

      Event description:

      INIT = Inbound Call

      CON = Connection (Asnwering)

      INT = Throughconnect

      DIS = Disconnected (Hangup)

       

      Call IDRecNoEventCodeEventTime
      1231INIT12:01:53
      1232CON12:02:06
      1233INT12:02:15
      1234CON12:02:23
      1235INT12:02:30
      1236CON12:02:45
      1237DIS12:03:01

       

      Now I need a set with the time of the second CON-event per CallId that is after the first INT. I hope someone knows how to do......

       

      Best regards,

       

      Arjan

       

      Message was edited by: arjanijlenhave