English (US)

Is it possible to create a Cumulative Query on tickets volume?

Answered
Anatolii

Hi there! I need to have a report in which I can see the total volume of tickets by status on a given day. So, if I have 20 new tickets per day and all of them are being solved, I would have:

1st day: 20 new 0 solved

2nd day: 20 new 20 solved

3rd day: 20 new 40 solved

Here is an inspiration for this: https://confluence.atlassian.com/jirasoftwarecloud/cumulative-flow-diagram-777002689.html

I would be very grateful if someone could point me in the right direction. Thank you!

 

1 Comments

  • Graeme Carmichael
    Community Moderator

    Anatolii

    Try this:

    Use the Support Ticket Updates dataset.

    Metrics

    • Count Tickets Created

    Then use the dual Access button to enter

    • D_COUNT( Tickets Solved)

    Columns

    • Update Date

    Filter

    • Update Date - select the date range that you want

    Result Manipulation

    • Result Path Calculation

    • Chart Configuration > Auto

    And that gave me:

     

    2

Please sign in to leave a comment.

Didn't find what you were looking for?

New post
Powered by Zendesk