I have a matrix report and want it to be a graph report.
Sorry I am not at all adept at SQL and I need a matrix report converted to a graph report, how do I do this?
The data is there, but I want it in a Graph format with more than one field.
I want the number of tickets lodged per department and the number of tickets completed per department for a defined period of time (previous week). I have a matrix with number completed per department but am having some trouble converting to a graph or adding the extra field (number completed).
The query is:
SELECT dpt.DEPTNAME 'Department',wo.WORKORDERID 'Request ID',wo.COMPLETEDTIME 'Completed Time' FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE ((((( std.STATUSNAME = 'Closed') OR ( std.STATUSNAME = 'Resolved')) AND (((( qd.QUEUENAME = 'IS ICT Help Desk') OR ( qd.QUEUENAME = 'IS ICT Network Admin')) OR ( qd.QUEUENAME = 'IS ICT Purchasing')) OR ( qd.QUEUENAME = 'IS ICT Server Admin'))) AND ((wo.COMPLETEDTIME >= $P{fromdate}) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL)))) AND ((wo.COMPLETEDTIME <= $P{todate}) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL)))) AND wot.THD_WOID=wot.WORKORDERID ORDER BY 3
Thanks.
Brad.
The data is there, but I want it in a Graph format with more than one field.
I want the number of tickets lodged per department and the number of tickets completed per department for a defined period of time (previous week). I have a matrix with number completed per department but am having some trouble converting to a graph or adding the extra field (number completed).
The query is:
SELECT dpt.DEPTNAME 'Department',wo.WORKORDERID 'Request ID',wo.COMPLETEDTIME 'Completed Time' FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE ((((( std.STATUSNAME = 'Closed') OR ( std.STATUSNAME = 'Resolved')) AND (((( qd.QUEUENAME = 'IS ICT Help Desk') OR ( qd.QUEUENAME = 'IS ICT Network Admin')) OR ( qd.QUEUENAME = 'IS ICT Purchasing')) OR ( qd.QUEUENAME = 'IS ICT Server Admin'))) AND ((wo.COMPLETEDTIME >= $P{fromdate}) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL)))) AND ((wo.COMPLETEDTIME <= $P{todate}) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL)))) AND wot.THD_WOID=wot.WORKORDERID ORDER BY 3
Thanks.
Brad.