Hi All
Got a question around the Agent Historical All Fields CUIC report - and happens in Webview migrated reports too.
When you report on an agent it lists times for all skills. This is fine for Active Time, Reserved, Wrap, Busy Other in the summaries.
However for Log On Duration, Not Active Time, Not Ready Time etc it lists the same amount of time for each skill but in the summary it sums them all togther.
So for example if an agent was logged on for 7 hours and was a member of 3 skills it would show 7 hours logon to each skill which it then summarizes into 21 hours at the bottom when really the agent has only been logged on for 7 hours.
In Webview this worked fine and only showed the actual amount of logged on time, not the time for each skill all added together.

So the question is, how can you get CUIC to behave like webview in the summary for LoggedOnDuration and only show 1, not all 3. And also have it show the correct total report summary?? Does it need the sql changing or can it be done in the summaries?
Attached a picture of what I'm trying to explain, let me know if need more description.
Greatful of some pointers this has been doing my head in all Friday afternoon lol!

Many Thanks

Attachments:

The problem is if you set it to average it will also do average for the whole report.
It needs to show the average for the agent (or the actual logged on time), then sum all the agents together for the report summary.
You can change the footers for each of the groupings, but I can't see a way to do it for the report summary so it sums instead of avearges.