Summary report by Technician of Time Taken
As a new custom report I created a report for a period that shows the Closure statistics by technician.
It has the count, average, minimum and max time taken to close requests in the period.
The issue I have is that it also has all the detail for each technician on the report as well, so I get all teh requests they have closed before I get the stats at the end.
What part of the report wizard do I need to use to tell it not to give me the details, just the summary bits.
The report itself when shown as a query is:
Working on a MS SQL environment.
If you run the above the figures are displayed incorrectly in comparison to the output you get when it is produced via the Tabular wizard but it give the essence of what I am trying to achieve.
Help/guidance/point to the bit in the manual greatly recieved.
Regards,
Andy
It has the count, average, minimum and max time taken to close requests in the period.
The issue I have is that it also has all the detail for each technician on the report as well, so I get all teh requests they have closed before I get the stats at the end.
What part of the report wizard do I need to use to tell it not to give me the details, just the summary bits.
The report itself when shown as a query is:
SELECT ti.FIRST_NAME 'Technician',wo.WORKORDERID 'Request ID',cd.CATEGORYNAME 'Category',scd.NAME 'Sub Category',wo.TIMESPENTONREQ 'Time Spent',ti.FIRST_NAME 'Technician' FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID WHERE (((wo.COMPLETEDTIME >= <from_thisweek>) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL))) AND ((wo.COMPLETEDTIME <= <to_thisweek>) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL)))) AND wot.THD_WOID=wot.WORKORDERID ORDER BY 1
Working on a MS SQL environment.
If you run the above the figures are displayed incorrectly in comparison to the output you get when it is produced via the Tabular wizard but it give the essence of what I am trying to achieve.
Help/guidance/point to the bit in the manual greatly recieved.
Regards,
Andy