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

Answered
image avatar

Tommy

Posted Oct 16, 2019

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!

 

0

4

4 comments

      image avatar

      Cardenas, Romulo

      Hi Dane,

       

      yes, both columns are displayed. 

      0

      image avatar

      Dane

      Hi Romulo,
       
      Are you pertaining to the column values highlighted in green?
       

      As it turns out, there's no option to remove it on the current chart configuration.

      0

      image avatar

      Cardenas, Romulo

      Hi,

      i generate a similar  graphich based on a specific (number of tickets per month starting AND cumulative number of tickets).

      Is there a way to hide the data values on the columns and keep only those in the cumulative line?

      Romulo

      0

      image avatar

      ZZ Graeme Carmichael

      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:

       

      0

      Sign in to leave a comment.

      Didn't find what you're looking for?

      New post