We've used some of the SQL from the stock CUIC reports to extract the interval aggregated data, what we're looking for now is a way to be able to take the raw data from the Termination_call_detail tables etc and to be able to calculate calls offered, answered, talk time queue time etc.
We're getting close with the numbers but can't match them exactly to the CUIC report, so it looks like there's some additional filters that we're not aware of and can't determine from the data or the supplied database schema.
Previously we were able to provide things like talk time in minute by minute buckets, even things like a daily average is now difficult with the aggregated data.
We're also having issues with things like abandonment rates, a call can come in at 09:59 so will be in the 09:45 interval, but abandon at 10:01. When calculating abandonment we look at abandoned / calls offered, but using the interval figures the call offered was in the previous interval, so an hourly abandonment would possibly be wrong. Previously we would have for example a CallID, then a flag for offered and a flag if it was abandoned, allowing us to easily calculate an abandonment rate.
I thought if i could see how the Router_Queue_Interval calculates fields then I might be able to recreate some of the measures.
