I'm trying to get Explore to calculate a specific KPI to measure the effectiveness of the answer bot and I'm struggling!
What I would like to do is create a simple percentage showing how many of the total solved tickets in a month were solved by the answer bot as opposed to an agent. The problem is that these measurements exist in two separate datasets, total solved tickets in support and total solved by the bot is in the Guide.
I've tried cloning a solved tickets query from the support guide but this throws an error. I can easily get a resolution rate for the bot but comparing against the support tickets as a whole seems impossible?