Contact Center Reporting

« Back to Contact Center Reporting

Custom formula

Combination View Flat View Tree View
Threads [ Previous | Next ]
Custom formula
custom formula
Answer
2/24/12 11:39 PM
i am trying to create CUIC custom formuale for the footer.
 
from the query, i see 

 
 
asa= case when sum(isnull(CTHH.CallsAnsweredToHalf,0)) = 0 then 0
else sum(isnull(CTHH.AnswerWaitTimeHalf,0)) * 1.0
/ sum(isnull(CTHH.CallsAnsweredToHalf,0))
end,

 
Now, how does this converts to the formulae in footer, so i get to see the average (or summary) in footer.
 
Thanks
Senthil
Flag

RE: Custom formula
Answer
2/25/12 12:10 AM as a reply to Senthil Kumar Natarajan.
Here are the footer formula, in case anyone needs it (i got these from the exisiting CallType Historical definition.
 
asa = SUM(${CallDelayAbandTime}) / SUM(${TotalCallsAband})
per_aban = SUM(${CallsAband})/SUM(${CompletedTasks})
per_queued = SUM(${CallsQHandled})/SUM(${CallsHandled})
avg_aban_delay = SUM(${delaytime}) / SUM(${CallsAband})
 
-senthil
Flag