[font="times new roman"]Need help generating two reports based on custom entries I have made to Impact and Category

1. Total tickets per month based on each unique Impact option
2. Total tickets per month based on each unique Category option


Want to use this as a trending mechanism

Thanks in advance
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
Something like this?
SELECT I.NAME AS IMPACT,
DATE_FORMAT(H.CREATED, '%M-%Y') AS MONTH_YEAR,
COUNT(*) AS NUMBER_OF_TICKETS
FROM HD_TICKET H,
HD_IMPACT I
WHERE H.HD_IMPACT_ID = I.ID
GROUP BY I.NAME,
DATE_FORMAT(H.CREATED, '%M-%Y')
ORDER BY H.CREATED

SELECT C.NAME AS CATEGORY,
DATE_FORMAT(H.CREATED, '%M-%Y') AS MONTH_YEAR,
COUNT(*) AS NUMBER_OF_TICKETS
FROM HD_TICKET H,
HD_CATEGORY C
WHERE H.HD_CATEGORY_ID = C.ID
GROUP BY C.NAME,
DATE_FORMAT(H.CREATED, '%M-%Y')
ORDER BY H.CREATED


I would also check out these 2 links, I think they might help.

Accessing the KBOX DB:
[link]http://www.kace.com/support/kb/index.php?action=artikel&cat=9&id=9&artlang=en[/link]

SQL Tutorial:
[link]http://www.w3schools.com/sql/default.asp[/link]
Answered 03/14/2011 by: dchristian
Red Belt

Please log in to comment
0
Thanks

I get this error:

Error Running ReportException while running report. Unknown column name : ID[/align]
Answered 03/14/2011 by: eschlesinger
Yellow Belt

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