Report Request - # of Tickets per category
I don't know much SQL and the report wizard does not seem to be able to cut it for me - I need a report that just provides me the raw numbers for the past 31 days of the number of tickets per category. So for example, I'd want to see something like:
Hardware::Printers - 30
Hardware::Monitors - 23
I don't care what the ticket status is, just that it is every ticket within the last 31 days.
Other reports that would be helpful in this same style would be # of tickets in each IMPACT type and # of tickets of each priority type (each for the past 31 days).
Has anyone done this already or can assist in writing/creating the report? Using the wizard, it breaks it out with a category as a heading, then lists all the tickets with ticket # and detail under that heading. I have to manually count each one to add them up.
There are no answers at this time