Second connection

[Anonymous]

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 ID	RecNo	EventCode	EventTime
123	1	INIT	12:01:53
123	2	CON	12:02:06
123	3	INT	12:02:15
123	4	CON	12:02:23
123	5	INT	12:02:30
123	6	CON	12:02:45
123	7	DIS	12: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

[CELAMBARASAN]

Hi,

     Have CallID as dimension.

     Interval(Max({EventCode={'CON'}} EventTime)-Only({<EventCode={'INT'}>} EventTime),'hh:mm:ss') as expression

Hope it helps

Celambarasan

[Anonymous]

Hi Celambarason,

Thanks for helping!

I've edited my discussion....How to do now?

Arjan

[CELAMBARASAN · Accepted solution]

Hi,

     For this you have to arrive value in the load script.

     Load the data by using order by callID , EventCode,EventTime in ascending order.

     Then

     Load

          *,

          Autonumber(EventCode&EventTime,CallID&EventCode) as Number

     Resident tableName;

Then you can easily picked up based on the number.

     Interval(Only({EventCode={'CON'},Number={2}} EventTime)-Only({<EventCode={'INT'},Number={1}>} EventTime),'hh:mm:ss')

Hope it helps

Celambarasan

[Anonymous]

Thanks for your help!!!

Arjan