CMS-Designer reports 1

[jghadiali]

Hi,

I have designed a report using 'dagent' table. When i add a custom calculation AHT(ACDTIME+ACWTIME+HOLDTIME/ACDCALLS), I am not able to run the report. I get the error :
data
The column must be in the GROUP BY list.

If I remove this calaculation from the query, the report runs fine. But, I need this calculation in the report.

Need to know what items have to be included in the 'GROUP BY' list.


Thanks n regards,
Jigs

 

[smurfyIAG]

If other fields in your report are aggregated e.g. sum(acdcalls) then non-aggregated fields need to be used as groups (standard SQL rules).

Solution - remove the aggregation from the other fields or add aggregation to this calculation ...
(sum(ACDTIME)+sum(ACWTIME)+sum(HOLDTIME))/sum(ACDCALLS)

however, your current AHT calculation is not accurate either...
Try this...
(sum(I_ACDTIME + I_ACWTIME + I_DA_ACDTIME + I_DA_ACWTIME + I_RINGTIME) + sum(I_ACDOTHERTIME + I_ACDAUXINTIME + I_ACDAUX_OUTTIME))/SUM(ACDCALLS)

Hope that helps

Sean Murphy
Call Centre Analyst
IAG New Zealand