How do I calculate how many tickets are in pending status each day?
Hello,
We are trying to create a query to calculate the number of pending status tickets at the end of each day. We have tried the backlog and ticket updates datasets, but nothing matches what we are looking for.
-
Hey Jenny,
You should be able to use the backlog dataset to get this information. I would try something like the following with the status being filtered for pending tickets:
Best regards,
-
In order to obtain this information, it is likely that you will be able to use the backlog dataset. If I were you, I would try something like what is shown below, with the status being filtered for pending tickets:
-
Thank you, Alex!
Also, is there any way to filter by ticket form on the backlog history dataset?
-
Hey Jenny,
Looks like ticket form filter is going to be added to the backlog dataset soon as you can read here but is not available at the moment.
Best regards,
Iniciar sesión para dejar un comentario.
4 Comentarios