Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,299,996
Community Members
 
Community Events
165
Community Groups

Need historical totals of tickets in a specific status over time plotted in a graph.

I need historical totals of tickets in a specific status over time, plotted in a graph.

I am using company manged, Jira cloud.

My tickets can progress through multiple statues over their lifetime, not just; created, in progress, done status categories.

I need to determine over a range of time, how many tickets were in a particular status on a per day, per week, etc. basis.

After reading the documentation it looks like this is not possible out of the box, nor with JQL, nor with JQL script runner. It looks like scraping ticket history status transitions using the REST api is the only way, or possibly a third party add-in like "Arsenal Dataplane." Does anyone out there know how to solve this problem?

2 answers

4 votes

Hi @Arnold 

Yes, unfortunately it's not possible without the out the box solutions.

I recommend you to try Time in Status for Jira Cloud. It's simple in use and completely fits your needs.

Its reports can help to solve your issue. Just choose the one that fits you the best and Determine date ranges:

Status Count report shows how many times an issue has been in each status during the particular period.

statuscountreport.png

Time in Status report shows how long the issues has spent in each status of the workflow.

tis report.png

Time in Status per Date report sums the time the task has been in a particular status during the chosen period.

This add-on is developed by my team and is free for using up to 10 users. Please, let me know if you have any additional questions.

Mariana, The example screen shots do not cover my use case, but I will see if I can get it installed and give it a try, e.g. I have many more statues that just the statusCategories "To Do", "In Progress", and "Done" Also the Status count report shows a count for how many times an issue has been in each status. I need for all issues in the project, how many tickets are in each status, at a particular time in the past. But I will try it any way to see if there are other possibilities with the add-in.

I hope you find the functions that will help you.

If you need any help, contact our support:  support@saasjet.com 

0 votes

Hello Arnold,

I think the thing closest to what you want is the Cumulative Flow Diagram. It should be available as a report option on Scrum boards.

https://support.atlassian.com/jira-software-cloud/docs/view-and-understand-the-cumulative-flow-diagram/

EmreT

Emre T, Nope; the Cumulative Flow diagram does not help at all. The answer is in the title, i.e. Cumulative. I do not want/need cumulative over time. I need the actual number of tickets in a particular status at any particular time graphed. I did reread the documentation, and even the example indicates why this will not work for me. e.g. ToDo fixed at five, even when done is >0.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

15,043 views 38 49
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you