Hello, I've been asked to create a query that shows the percentage of chats with a first reply time less than 3 minutes. I created a table that allows me to manually calculate this (shown below), however is it possible to make something that simply shows a percentage?
Ticket ID is not necessary, nor is the actual duration. We do need to be sure the Engagement date is set for Yesterday though.
Any advice would be greatly appreciated!
Please sign in to leave a comment.