Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
i have an sample data with that need to find the Average handle time by using set analysis.
can any one help me out for this.
find the below sample data to get an average handle time.
I tried below script but i'm not getting data for this.
=aggr(num(avg(count({<flag_handled={'1'}>}Distinct[ININ_Interaction_key]),[Ringing_Time_sec]),'##.00')
ININ_Interaction_key | Ringing_Time_sec |
40325314 | 45.7 |
50096740 | 45 |
28872864 | 31.3 |
50096740 | 45 |
56342922 | 47.9 |
48854972 | 39.2 |
34762680 | 41.5 |
24833765 | 48.8 |
21637678 | 32.1 |
7862109 | 43.4 |
24833765 | 48.8 |
44428480 | 29 |
56318300 | 35.3 |
41580227 | 43.6 |
Thanks in Advance
Hi, just using Avg([Ringing_Time_sec]) or Avg({<flag_handled={'1'}>} [Ringing_Time_sec]) can't work?
so what do i need to mention to get a result of an average handle time
I don't understand your question. Have you tried Avg([Ringing_Time_sec])?
Try to be more clear with your requirements. In which object do you want to use this? what is the expected result?