anon28066628 | 2018-01-05 15:31:17 UTC | #1
When using the analytics Conversation Aggregate Query, filtering by queueId "NotExists" is not supported. An error message indicates "The only dimensional operator supported is EQUALS".
However, if you group by queueId, then you may find groups with no queueId. These are non-ACD calls. So while you cannot ask for non-ACD (non-Contact Center) aggregate metrics directly, you can access them through grouping by Queue.
// Sample Query
{ "interval": "2017-10-01T04:00:00.000Z/2017-10-31T04:00:00.000Z", "groupBy": ["queueId"], "filter": { "type": "or", "predicates": [{ "type": "dimension", "dimension": "mediaType", "operator": "matches", "value": "voice" }] }, "metrics": ["tTalkComplete"] } ``
Sample result. Note there are 21 voice calls in the group with "voice" but no queueId. These are non-ACD calls. There are 9 calls in the group with both "voice" and "queueId" that were routed to a Queue.
{ "results": [{ "group": { "mediaType": "voice" }, "data": [{ "interval": "2017-10-01T04:00:00.000Z/2017-10-31T04:00:00.000Z", "metrics": [{ "metric": "tTalkComplete", "stats": { "max": 30606, "min": 3632, "count": 21, "sum": 261293 } }] }] }, { "group": { "mediaType": "voice", "queueId": "6d8d73de-0dc1-48d2-b41a-cd37074526b5" }, "data": [{ "interval": "2017-10-01T04:00:00.000Z/2017-10-31T04:00:00.000Z", "metrics": [{ "metric": "tTalkComplete", "stats": { "max": 70666, "min": 2232, "count": 9, "sum": 266344 } }] }] }] }
system | 2018-02-05 15:39:05 UTC | #2
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.
This post was migrated from the old Developer Forum.
ref: 2309