Set Analysis

[jaswanthchitra9]

Hi Everyone,

for the below data need to findout the average handle time for this field (Ringing_time_sec ). so here we need to caluculate the average in secs. Can any one help me out on this.

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

[BrunPierre]

If you wish to get the average of the table in which the "Ringing_Time_sec" is present, then with this

=Avg(Ringing_Time_sec) 

or perhaps you indeed to sum of 'Ringing_Time_sec' for all ININ_Interaction_key, and then average it. Then as below.

=Avg(Aggr(Sum(Ringing_Time_sec), ININ_Interaction_key))

[jaswanthchitra9]

Thanks for the reply. so if we get an average into Seconds what should i do.

[BrunPierre]

Format output with an interval function as below.

=Interval( Avg( Interval#(Ringing_Time_sec,'hh:mm:ss')), 'ss')