CMS Supervisor RONA Report HELP

[jr88ps69]

We have added RONA into our call center and i want to have the number of RONA calls listed per agent in historical split\skill, summary daily

I know that i need to go into the report in design mode and add noansredir but how do i add it. I always get errors when I try. Thanks

 

[AvayaTier3]

http://www.tek-tips.com/viewthread.cfm?qid=1537890&page=1

A great teacher, does not provide answers, but methods to teach others "How and where to find the answers"

bsh

35 years Bell, AT&T, Lucent, Avaya
Tier 3 for 25 years and counting

http://bshtele.com

 

[jr88ps69]

yeah I am waitng for them to give me permissions to save exception

what I am looking for in my above question is how to do in in design veiw of the report i posted?

 

[Stinney]

We have a custom report built that provides a report for multiple agents, multiple days, multiple intervals. It will only report if the agent had RONAs.

The data is from the hagent table.

The Inputs (all with multi-value selected) are:
Agent
Date
Time (point in time)

Query Items are:
ROW_DATE
STARTTIME
"-"
STARTTIME+INTRVL
LOGID
""
LOGID
NOANSREDIR

The Where statement is:
ACD=$acd and LOGID = [Agents:] and ROW_DATE = [Dates:] and STARTTIME = [Times:] AND NOANSREDIR > 0


- Stinney

Favorite all too common vendor responses: "We've never seen this issue before." AND "No one's ever wanted to use it like that before.

 

[jr88ps69]

PLease be more specific I am still receiving when you add this inof which query are you using data or totals? please help I just want to use the above report with the RONA info I dont want anything else

 

[Stinney]

Edit your queries:

data: add NOANSREDIR and save

totals: add NOANSRDIR, Highligh NOANSRDIR in the Query Items: window, click on Edit, change it to sum(NOANSREDIR) and save

Click on the table to highligh it. Goto Format|Table

Click on the Data Tab

Add NOANSREDIR to the Data on Table window

Save and Run



- Stinney

Favorite all too common vendor responses: "We've never seen this issue before." AND "No one's ever wanted to use it like that before.

 

[jr88ps69]

Ok got it thanks a bunch