Is it possible to create a Cumulative Query on tickets volume?
AnsweredHi 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!
-
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:
Please sign in to leave a comment.
1 Comments