CMS custom report shows a total for skill column

[FicBen]

Good day all,

In CMS, I took the Group Summary Daily report and modified it so it will list a line for each skill the agent logs into. I also added a column that will list the skill number. I noticed in the Totals line, there's a number listed for the skill number. How would I get rid of this? I don't see anything in the totals query that would populate this field. Here are my query items for totals:

'Totals'
dagent.sum(TOTAL_ACDCALLS)
dagent.AVG_AGENT_TALK_SUM
dagent.AVG_AGENT_ACW_SUM
dagent.sum(EXT_CALL_IN)
dagent.AVG_TALK_TIME_IN_SUM
dagent.sum(EXT_CALL_OUT)
dagent.AVG_TALK_TIM_OUT_SUM
dagent.sum(TOTAL_I_ACDTIME)
dagent.sum(TOTAL_I_ACWTIME)
sum(dagent.I_RINGTIME)
sum(dagent.TI_OTHERTIME)
sum(dagent.TI_AUXTIME)
sum(dagent.TI_AVAILTIME)
sum(dagent.TI_STAFFTIME)
100 * (SUM(I_RINGTIME + I_ACDTIME + I_ACDOTHERTIME + I_ACDAUX_OUTTIME + I_ACDAUXINTIME + I_ACWTIME) / sum(TI_STAFFTIME - TI_AUXTIME + I_ACDAUX_OUTTIME + I_ACDAUXINTIME))
100 * (sum(I_RINGTIME + I_ACDTIME + I_ACDOTHERTIME + I_ACDAUX_OUTTIME + I_ACDAUXINTIME) / sum(TI_STAFFTIME - TI_AUXTIME + I_ACDAUX_OUTTIME + I_ACDAUXINTIME))

Where statement: ROW_DATE = [Date:] and ACD=$acd and LOGID in (select value from agroups where item_name = [Agent Group:] and acd_no=$acd)


I also checked the table format and could not see anything there that would remove it.

Thanks!

 

[Stinney]

What's your query items for data? I bet the first column is skill.

- Stinney
"Scire ubi aliquid invenire possis, ea demum maxima pars eruditionis est"

"To know where to find anything is, after all, the greatest part of education"

 

[FicBen]

It's the second item listed. Here's the data query:

dagent.LOGID
SPLIT
dagent.sum(TOTAL_ACDCALLS)
dagent.AVG_AGENT_TALK_SUM
dagent.AVG_AGENT_ACW_SUM
dagent.sum(EXT_CALL_IN)
dagent.AVG_TALK_TIME_IN_SUM
dagent.sum(EXT_CALL_OUT)
dagent.AVG_TALK_TIM_OUT_SUM
dagent.sum(TOTAL_I_ACDTIME)
dagent.sum(TOTAL_I_ACWTIME)
sum(dagent.I_RINGTIME)
sum(dagent.TI_OTHERTIME)
sum(dagent.TI_AUXTIME)
sum(dagent.TI_AVAILTIME)
sum(dagent.TI_STAFFTIME)
100 * (sum(I_RINGTIME + I_ACDTIME + I_ACDOTHERTIME + I_ACDAUX_OUTTIME + I_ACDAUXINTIME + I_ACWTIME) / sum(TI_STAFFTIME - TI_AUXTIME + I_ACDAUX_OUTTIME + I_ACDAUXINTIME))
100 * (sum(I_RINGTIME + I_ACDTIME + I_ACDOTHERTIME + I_ACDAUX_OUTTIME + I_ACDAUXINTIME) / sum(TI_STAFFTIME - TI_AUXTIME + I_ACDAUX_OUTTIME + I_ACDAUXINTIME)), NOANSREDIR FROM dagent