Need Report Help
[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
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
Answers (2)
Please log in to answer
Posted by:
dchristian
13 years ago
Something like this?
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]
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.CREATEDSELECT 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.CREATEDI 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]
Posted by:
eschlesinger
13 years ago
Thanks
I get this error:
Error Running ReportException while running report. Unknown column name : ID[/align]
I get this error:
Error Running ReportException while running report. Unknown column name : ID[/align]
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.