Okay, I'm having a problem.
Using Microsoft Access and ODBC connectivity to the queries on the AWDB, I have been able to successfully re-create the Agent Consolidated Daily Report.
Now I am trying to re-create the Agent Team Consolidated Daily Report and my time calculations are just not giving me the same numbers as the Cisco WebView report.
I've attached screen prints.
Any help would be greatly appreciated!!!!
BTW, I am doing this because not everyone in my organization has access or knowledge of SQL, and there are other reports our end users want that are not currently available from WebView. I am re-creating these as learning tools to familiarize myself with the data and the different calculations.