crabbypatty80
Technical User
Hello!
I have recently been asked to create a custom report for multiple split skills per interval(Historical). I designed the report based on the v13 CMS report named Summary Interval. I have changed the "Where" clause so that it looks like this:
ROW_DATE = [Dates:] and STARTTIME = [Times:] and SPLIT = [Splits/Skills:] and ACD=$acd GROUP BY STARTTIME
So currently I am only able to get 3 columns to show up. They are Time, ACD Calls and Aban Calls. I am also wanting the Avg Speed of Ans, Avg ACD Time and Avg ACW Time. I am having a very difficult time doing this.
Also, the columns for Time and ACD have the correct totals at the top of the field, however the column with Aban Calls is summing in time format (ex 0:53) and not a total call sum.
Is there anything I can do to correct these errors?
Thanks!
Christian
I have recently been asked to create a custom report for multiple split skills per interval(Historical). I designed the report based on the v13 CMS report named Summary Interval. I have changed the "Where" clause so that it looks like this:
ROW_DATE = [Dates:] and STARTTIME = [Times:] and SPLIT = [Splits/Skills:] and ACD=$acd GROUP BY STARTTIME
So currently I am only able to get 3 columns to show up. They are Time, ACD Calls and Aban Calls. I am also wanting the Avg Speed of Ans, Avg ACD Time and Avg ACW Time. I am having a very difficult time doing this.
Also, the columns for Time and ACD have the correct totals at the top of the field, however the column with Aban Calls is summing in time format (ex 0:53) and not a total call sum.
Is there anything I can do to correct these errors?
Thanks!
Christian