I am trying to create a report that will graphically represent the number of open and closed tickets of each month for one whole year. For example 

J anuary: open 30 closed 420

February : open 21 closed 320

Where my current report fails to show at the end of each month the number of active incidents. I have added a screenshot and the query

 

SQL Query

SELECT wo.WORKORDERID "Ticket ID",cd.CATEGORYNAME "Category" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE  (((wo.CREATEDTIME >= datetolong('2013-01-01') AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= 1371650399000) AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1))))  AND wo.ISPARENT=1 AND wo.IS_CATALOG_TEMPLATE=0

Thanks in advance.