custom query report help
dear support team
i need a MONTHLY report that shows our engineers performance based on their group, we are using SDP 7604 with MySql.
The report columns are :
1. Name : a engineer of a particular group.(let's say "Network" group here)
2. Requests Assigned: number of requests assigned to him (not the group)
3. Requests Closed: number of closed requests
4. Total Time Spend: total time spend of all his closed requests (HH:MM)
5. Avg Resolution Time：his average resolution time (HH:MM)
and the report should be descendingly ordered by column 4 .
and is it possible to add a summary row below the actual report data which sums up column 2，3，4 respectively，for column 5 just calculate "the Avg Resolution Time of all closed requests of all the engineers in the report"
thank you very much.
Ralph
i need a MONTHLY report that shows our engineers performance based on their group, we are using SDP 7604 with MySql.
The report columns are :
1. Name : a engineer of a particular group.(let's say "Network" group here)
2. Requests Assigned: number of requests assigned to him (not the group)
3. Requests Closed: number of closed requests
4. Total Time Spend: total time spend of all his closed requests (HH:MM)
5. Avg Resolution Time：his average resolution time (HH:MM)
and the report should be descendingly ordered by column 4 .
and is it possible to add a summary row below the actual report data which sums up column 2，3，4 respectively，for column 5 just calculate "the Avg Resolution Time of all closed requests of all the engineers in the report"
thank you very much.
Ralph