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.
How do I calculate how many tickets are in pending status each day?
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,
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,
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
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,