Recent searches

No recent searches

How do I calculate how many tickets are in pending status each day?

Answered
image avatar

vip daman games

Posted May 26, 2023

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.

 

0

1

1 comment

Date
    image avatar

    ZZ Graeme Carmichael

    Community Moderator

    In Explore, use the Support Backlog History dataset.

    Metrics

    • Sum Tickets

    Rows

    • Backlog Recorded date

    Filter

    • Status = Pending
    • Backlog recorded date, for example, the last week

    The Backlog History dataset takes a snapshot of your account at the end of each day. That is best place to see the total pending tickets each day and how they move from day to day.

     

    0

    Please sign in to leave a comment.

    Didn't find what you're looking for?

    New post