Thanks Jerome,
I am using the Conversation Aggregate Query and I have tested with nConnect for a specific user. I have also added other metrics. Here is the query.
{
"interval": "2021-10-10T22:00:00.000Z/2021-10-16T22:00:00.000Z",
"groupBy": [
"userId"
],
"filter": {
"type": "and",
"predicates": [
{
"type": "dimension",
"dimension": "userId",
"operator": "matches",
"value": "2f105b41-ab63-4bd6-a2d4-42b5fe5fcd3c"
},
{
"type": "dimension",
"dimension": "mediaType",
"operator": "matches",
"value": "voice"
}
]
},
"views": [],
"metrics": [
"nConnected",
"nOutbound",
"nTransferred",
"tAcd",
"tAcw",
"tDialing",
"tTalk"
]
}
Here is the result for a given week:
{
"results": [
{
"group": {
"mediaType": "voice",
"userId": "2f105b41-ab63-4bd6-a2d4-42b5fe5fcd3c"
},
"data": [
{
"interval": "2021-10-10T22:00:00.000Z/2021-10-16T22:00:00.000Z",
"metrics": [
{
"metric": "tAcw",
"stats": {
"max": 55971000,
"min": 2000,
"count": 10,
"sum": 56582000
}
},
{
"metric": "tDialing",
"stats": {
"max": 32372,
"min": 522,
"count": 11,
"sum": 101003
}
},
{
"metric": "tTalk",
"stats": {
"max": 1109221,
"min": 297,
"count": 24,
"sum": 6117292
}
}
]
}
]
}
]
}
I have run a report for the same user and the user had 14 non-Acd and 10 Acd voice interactions, 24 in total. I find under tTalk the count = 24 which is the correct for the total interactions. Under tACW i find 10 which is correct for ACD interactions. If I subtract tTalk(24) - tAcw(10) i got 14 which is correct for Non-Acd interactions. I also find 11 under tDialing and by looking at details in the interaction display for the user on the same dates I found that the user had 11 outbound non-Acd calls and 3 inbound non-ACD calls.
Do you know if this is a correct way to the number of calls for a user?
Regards
Rune