Recent searches


No recent searches

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

Answered


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

ZZ 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:

 

0


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

Dane

Zendesk Engineering

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


Hi Dane,

 

yes, both columns are displayed. 

0


Please sign in to leave a comment.

Didn't find what you're looking for?

New post