I have the following formula:

 

Local NumberVar myHours;
Local NumberVar myMinutes;
Local NumberVar mySeconds;

mySeconds := Average ({queue_performance_all.RingTime}, {queue_performance_all.CallDateTime}, "daily");
myHours := mySeconds \ 3600;
mySeconds := mySeconds mod 3600;
myMinutes := mySeconds \ 60;
mySeconds := mySeconds mod 60;

ToText(myHours,0) & ":" & ToText(myMinutes,0) & ":" & ToText(mySeconds,0)

 

This works fine except I need the formula to change when there is a name change.  I've tried the following:

 

Local NumberVar myHours;
Local NumberVar myMinutes;
Local NumberVar mySeconds;

mySeconds := Average ({queue_performance_all.RingTime}, {queue_performance_all.CallDateTime}, "{queue_performance_all.QueueName}");
myHours := mySeconds \ 3600;
mySeconds := mySeconds mod 3600;
myMinutes := mySeconds \ 60;
mySeconds := mySeconds mod 60;

ToText(myHours,0) & ":" & ToText(myMinutes,0) & ":" & ToText(mySeconds,0)

 

The end result would be the following:

 

Company A             00:00:10

Company B             00:00:23

 

I'm trying to get the average ring time grouped by each company in the hr:mm:ss format.  Any ideas?

 

Thank you in advance.