Avaya Support Forums  

Go Back   Avaya Support Forums > Contact Center Applications

Thread Tools Search this Thread Display Modes
Old 11-11-2015, 11:52 AM
arunc arunc is offline
Hot Shot
Join Date: Sep 2014
Posts: 15
arunc has 10 reputation points
Default dAgent performance db double entry


I have created a custom reports using agent performance stat for a client. when i generate a day wise report i am getting a multiple entries(not duplicate values, the full day data comes as two different parts) for a few Agent. when i checked the dAgent performance stat table data, i was able to find two entries for the agent in a single day.

Now the client is asking two remove these double entry in the report, how can i remove those double entries?

When does multiple entries occur in the dAgent performance table?
Reply With Quote
Old 11-23-2015, 12:58 PM
jbrackin jbrackin is offline
Join Date: Sep 2011
Location: Galway, Ireland
Posts: 4
jbrackin has 10 reputation points

The Agent Performance view has multiple unique keys. The obvious two are the date time of the statistic and the unique ID of the agent. The one that is not as obvious is the current supervisor of the agent. If the agents showing duplicate entries are reassigned to another supervisor during their shift then two records will appear.

You need to either show or eliminate the supervisor as a group on the report. If you add one of the supervisor fields to your custom report you can confirm that this is why you have duplicates. There are several ways to ensure all you see are the rows of data grouped as agent and date time of the statistic. These include grouping by Agent and hiding the details row or writing a query that groups on Timestamp and Agent.

Hope that helps

Last edited by jbrackin; 11-23-2015 at 01:01 PM.
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -7. The time now is 04:53 AM.

This Forum is provided solely for the use and convenience of Avaya customers and partners. Use of the Forum is subject to the Terms and Use and Privacy Statement found at www.avaya.com. No other use is permitted. The Forum including all content posted is “AS IS” and Avaya expressly disclaims all warranties and/or guarantees as to its accuracy, reliability, usefulness, quality or non-infringement of intellectual property. Avaya reserves the right to remove any content posted on the Forum at any time and for whatever reason.

Avaya will not be liable for any content posted on this Forum, including, without limitation, any errors or omissions or for any losses or damages of any kind incurred as a result of use or reliance on any content, regardless of its origin.

You expressly understand and agree that you assume all risks associated with use or reliance on this content.