HelpDesk category reporting
My company utilizes an HR Shared Services department for HR Inquiries. They are essentially a call center for HR questions. They file tickets for each inquiry, and enter a category for each HelpDesk ticket they submit. I would like to be able to report on the number of tickets filed by category.
I setup a report in OTBI. I have the Category field setup as a "slice of the pie" and the "# of SRs" measure setup as the "Slice Size"(see first screenshot). I have "# of SRs" field sorted descending and filtered to show the top 10 results, and prompts for the ticket creation date and ticket status(see second screenshot). I did build a separate prompt for the dashboard I plan to post this report to.