I have a spreadsheet that I like to use to keep track of inbound calls received. I'd like to track the Inbound "Total New Tickets" received and compare them with the "Total COMPLETED tickets" done for the day, this way we get an idea what our incoming ticket to completed ticket ratio or percentage is. What would be the best way to capture this metric? The actual spreadsheet that I used is attached.
If we received "53" tickets that day and completed "70" what would be the TOTAL NEW TICKET (inbound) vs. COMPLETION ratio? i.e. For every 10 tickets received we are completing 15 or something like that. What would be the best formula approach for this? If you know a better way to do it, i'm all ears. Any help you could provide is greatly appreciated