Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Have CallID as dimension.
Interval(Max({EventCode={'CON'}} EventTime)-Only({<EventCode={'INT'}>} EventTime),'hh:mm:ss') as expression
Hope it helps
Celambarasan
Hi Celambarason,
Thanks for helping!
I've edited my discussion....How to do now?
Arjan
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
Thanks for your help!!!
Arjan