Hello,
 
I'm trying to add two custom fields in a Skill Group Historical Report. In this report, I'd like to be able to include a count of the calls where answered within 2 Minutes and 5 minutes. Here's the SQL I've tried, but it is producing an error. Can anyone help me with the correct query to create this field?
 
CallsLessThan2 = Sum(case when ISNULL(SGHH.AnswerWaitTime, 0) <= 120 then 1 else 0 end),
CallsLessThan5 = Sum(case when ISNULL(SGHH.AnswerWaitTime, 0) <= 300 then 1 else 0 end)
 
Thanks!