dAgent performance db double entry

[arunc]

Hi

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?

[jbrackin]

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