Set Analysis

[jaswanthchitra9]

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

[rubenmarin]

Hi, just using Avg([Ringing_Time_sec]) or Avg({<flag_handled={'1'}>} [Ringing_Time_sec]) can't work?

[jaswanthchitra9]

so what do i need to mention to get a result of an  average handle time

[rubenmarin]

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?