11-20-2018 07:17 AM - edited 03-14-2019 06:38 PM
Hi everyone,
A quick basic question followed up by a not-so-basic ones for data related to TerminationCallDetail
1. We know that a combination of RouterCallKey and RouterCallKeyDay gives us the unique call (a sequence number tells the sequence the call went through) . If I combine multiple rows based on unique combination of RouterCallKey and RouterCallKeyDay , would be it be a good idea to aggregate (SUM) the stats like RingTime, Duration , TalkTime, HoldTime etc).
2. In that case what PeripheralCallType should I use? The first in the sequence or Last ?
3. In case of Outbound calls (i-e PeripheralCallType = 9) I see that we almost always have RouterCallKey = 0 and RouterCallKeyDay = 0. Is not this violate the uniqueness rule? How can I differentiate between inbound/outbound calls
I have gone through multiple threads but couldn't get the any answer. Would appreciate a quick response . Thanks
08-22-2019 08:50 AM
08-30-2019 10:11 AM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide