Total Tickets for month / Total Closed / Total Remain Open / Total Reassign
Hello, I'm hoping someone can help.
I need to figure out how to do the following:
I need a report which shows the total number of calls received within a given period of time (example from 9/15/08 to 10/15/08, allowing the user to select the dates).
From that total number of tickets, I need it broke down to how many of those tickets were closed within that same time period; how many remain open and of the tickets remaining open, how many were reassigned.
I'm pulling this information from HEAT Call Logging System.
I hope someone can help.
Sastry Duvvuri replied
To get the required information you may have to write 3 formulas :
if TicketStatus = 'Closed"
if TicketStatus = 'Open"
if TicketStatus = 'Reassign"
Now place these formulas on your report details section and insert summaries to get the total count.