AVAYA CMS Supervisor Design Reports

Topic Views - 629

AS400 Systems Admin.

Campbell Hausfeld

AVAYA CMS Supervisor Design Reports
Can anyone please tell me what the following means:

The column must be in the Group By List?



Don't know but....
You may find the answer here http://www.telesavers.com/User%20Guides/CC/CMS%20Report%20Design%20Guide%2002-06.pdf

MI Capability Manager

Vertex DataScience Ltd

Avaya group by
You have a query that is summarising data e.g. sum(i_stafftime) but you have not used a group by clause at the bottom to show what to sum by.

For example:
Select dagent.row_Date, dagent.split, sum(dagent.I_stafftime) as Logon
where dagent.split = 1 or dagent.split = 2
Group by dagent.row_date, dagent.split

Direct Marketing Executivr


Avaya CMS Supervisor Design Reports
Hi Doreen

CCT conduct Avaya CMS Supervisor Training courses at our offices here in Bristol. I'll ask our trainer and see if she is able to help.

Craig Neilson

Want to add a comment?

Not found what you were looking for?

1. Try searching through our site.
2. Still not got an answer?

Why not ask the Call Centre Helper Community? Click here to ask your question