HI Team,
we were building the query via developer tool query builder to match the number of interactions hitting the queues based on the flow name. but the result is not matching when verified using the interaction view (filter applied : flow name, queues 3 numbers).
business requirement filter : number of interactions for entering to flow"A" wrt 3 queues(queue1, queue2 and queue3)
Query builder result : 1904
interaction view filter result : 1474
query generated via query builder :
{
"interval": "2022-10-04T04:00:00.000Z/2022-10-05T04:00:00.000Z",
"order": "asc",
"orderBy": "conversationStart",
"paging": {
"pageSize": "100",
"pageNumber": 1
},
"segmentFilters": [
{
"type": "or",
"predicates": [
{
"type": "dimension",
"dimension": "flowName",
"operator": "matches",
"value": "flow1"
},
{
"type": "dimension",
"dimension": "queueId",
"operator": "matches",
"value": "cfa5eb43-ab47-4e3c-9d42-91dde086c106"
},
{
"type": "dimension",
"dimension": "queueId",
"operator": "matches",
"value": "0fd121fe-aebf-4bc3-87fe-d0a5d9a8e602"
},
{
"type": "dimension",
"dimension": "queueId",
"operator": "matches",
"value": "d82afff4-a69a-422d-8b4f-ae6c4bc42f58"
}
]
}
]
}