Hi,

I have been looking though all the monthly report assistance requests and solutions posted on the site, and have tried a lot of the different suggestions, I am still unable to get the information I need.

I'm not a MySQL or DB wizard so please excuse my inability to even supply any parameters I have tried, mostly I use the cut and paste method out of other posts.

What I need is a report that has open tickets assigned to agent per month, closed tickets per agent per month and total number of closed tickets per month.

Thanks in Advance.

Fraser Waugh
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Here's a pretty basic report that might help.

It just looks at the created date of the ticket and then checks to see if its still open or closed.
SELECT U.FULL_NAME,
DATE_FORMAT(H.CREATED,'%Y-%m') AS MONTH,
IF(S.STATE = 'CLOSED','Closed','Open') as STATE,
COUNT(*) NUMBER_OF_TICKETS
FROM HD_TICKET H,
HD_STATUS S,
USER U
WHERE H.HD_STATUS_ID = S.ID
AND U.ID = H.OWNER_ID
GROUP BY FULL_NAME,
MONTH,
STATE
ORDER BY MONTH,
FULL_NAME
Answered 02/08/2012 by: dchristian
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity