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

[Arnold]

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?

[Mariana_Pryshliak_Saasjet]

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.

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

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.

[Arnold]

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.

[Mariana_Pryshliak_Saasjet]

I hope you find the functions that will help you.

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

[Richard Stimson]

@Arnold did you resolve this?

EasyBI seems to do this https://eazybi.com/accounts/1000/cubes/Issues/reports/187032-cumulative-flow-diagram

But I'm looking for other options using Dashboard Hub or a similar plugin. Let me if you have any ideas.

Rich.

[Emre Toptancı _OBSS_]

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

[Arnold]

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.