Hi,
We have a client that wants a single monthly report showing all the tickets for the preceding month with a summary that shows the number of tickets by Manager, by Status and by Reason, with an average time per ticket. I have used a "Tickets list by Manager and Status" as a base. I can get the average ticket time and the number of tickets included in the report but what I would like is a summary of the status and reason code similar to the built in report "Number of Tickets by Manager". When I look at the design of that report the data set is completely different to the other report.
My question - is it possible to have this sort of summarised total in the summary section of the report i.e. Manager name and number of tickets per that manager, Reason Code Name and number of tickets per reason code and Status name and number of tickets per that status?
Thanks for your assistance.
We have a client that wants a single monthly report showing all the tickets for the preceding month with a summary that shows the number of tickets by Manager, by Status and by Reason, with an average time per ticket. I have used a "Tickets list by Manager and Status" as a base. I can get the average ticket time and the number of tickets included in the report but what I would like is a summary of the status and reason code similar to the built in report "Number of Tickets by Manager". When I look at the design of that report the data set is completely different to the other report.
My question - is it possible to have this sort of summarised total in the summary section of the report i.e. Manager name and number of tickets per that manager, Reason Code Name and number of tickets per reason code and Status name and number of tickets per that status?
Thanks for your assistance.
Comment