saravanandvs | 2023-06-23 13:06:15 UTC | #1
Hi Team,
We have tried to get the average handle time value from Workspace in queue performance for particular interval. we got the below response.
To fetch average handle time, we have tried using the below API for the same interval. handle count value was same for both api and ui(Queue performance). For average handle time value we calculated using this formula Avg handle = sum value(millisecond) 8486361 converted to (141.43) minutes. after converting to minutes(141.43/97) divide by count value. we got value as 1m 45s.
Avg Handle value From UI is 1m 27s, but from API it is 1m 45s. both the values are mismatching.
Api url : /api/v2/analytics/conversations/aggregates/query
Kindly clarify whether the formula used is correct or not?
Regards, Saravanan
Eos_Rios | 2023-06-23 13:46:13 UTC | #2
rounddown( ( 8486361 / 97 ) / 1000, 0) = 87 = 1m27s
saravanandvs | 2023-06-26 03:55:01 UTC | #3
Thanks a lot for your support @Eos_Rios .
John_Carnell | 2023-06-29 15:14:37 UTC | #4
This post was migrated from the old Developer Forum.
ref: 20639