CallCentreVoice Topic AVAYA CMS Supervisor Design Reports

Created by:
Statistics:
Forum:
Quick links:

Doreen Boyle on 4/2/2008 17:44:41.
Topic has 3 posts; viewed 509 times.
Technology   [This topic is read only]
Forum List | Unified View | Latest Posts
Popular Topics | Editor's Choice | Voices WebLog

Advertisement
SER Solutions

Author

Comments

Doreen Boyle
AS400 Systems Admin.
Campbell Hausfeld

3 posts
0 friends welcomed

AVAYA CMS Supervisor Design Reports   [4/2/2008 17:44:41]

Can anyone please tell me what the following means:

The column must be in the Group By List?

You don't have the priviledges to view this user's post history

 

Steve Helm
Planning Centre Manager
Vertex

78 posts
0 friends welcomed

Don't know but....  [5/2/2008 15:09:16]

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

You don't have the priviledges to view this user's post history

 

Julian Dixon
MI Capability Manager
Vertex DataScience Ltd

303 posts
0 friends welcomed

Avaya group by  [5/2/2008 16:46:47]

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

You don't have the priviledges to view this user's post history

 
  

In Read Only View, you cannot reply to any topic