Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to work-out the % Progress over time

vincenzo_spatafora
Contributor
August 1, 2024

Dear Community,

I would like to report in Jira the Progress of the issues being resolved/closed in % and over the time.

So, for example, a table where you can see how many issues have been closed in the current month compare to the previous one and so a Progess in % can be provided.

I went through all the Jira gadgets and it seems to me there is NO such a chart.

I've found "Created vs Resolved" but it doesn't show the % Progress.

Would you know if it's possible then via specific/advanced JQL to output this % Progress over the time?

Thanks in advance and kind regards, Vincenzo.

1 answer

0 votes
Lisa Forstberg
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 1, 2024

Hi @vincenzo_spatafora

I think the "recently created chart"  is close to what you request. With that you can group the result by month and get a visual representation vertically on how many issues in a month are open(red) or resolved (green).  Hover over a bar to get the exact numbers. You will not get % with this though. 

There are plenty of addons on the marketplace for enhancing the reporting on top of the Jira data though. I see you are on an on prem deployment option, and we don't really know what version you are on but head over to reporting apps om marketplace for data center to look for more options.

 

Screenshot 2024-08-01 at 10.23.01.png 

best of luck

/Lisa

vincenzo_spatafora
Contributor
August 1, 2024

Dear @Lisa Forstberg,

thanks for your reply.

I use version 9.12.5.

I've come across this chart and I've thought it's more actually to show whether there is enough work for the team.

Unfortunately I can NOT install these "reporting apps" and thus I have thought if it would be possible to achieve the same with JQL I could do myself.

Kind Regards, Vincenzo. 

Like Lisa Forstberg likes this
Lisa Forstberg
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 1, 2024

Hi Vincenzo,

Sometimes having app restraints is a blessing in disguise as it urges us look for the simplest solution :-) 

Can you explain what you mean with % Progress over time?  What is the whole and what is the portion of your envisioned KPI percentage?

The "recently created chart" will show you the number of created tickets in a specific time period and how many of those are currently open vs resolved. 

The "created vs resolved chart" will give you numbers of tickets in the specific time period that was created and how many was resolved (note that the resolved tickets might have been created in a different time period)

Another gadget to look for is the "Filter counts". Here you set a base filter and then you can add JQL's on top of that to get a number count. Not a % but maybe close enough and more readable for the users that should consume the data?

With JQL you can query for a list of issues but it won't give you a % completion of tickets per a time period. So you would probably need to do a series of JQL queries to catch issues created and issues resolved in time periods of your choice. 

typically the JQL would need to include some sort of time period restriction, like created or resolved in a specific time period. Example to get issues created in the previous month you would need to use:

created >= startOfMonth(-1) and created <= startOfMonth()

and also to get resolved issues  in the previous month: 

resolved >= startOfMonth(-1) and resolved <= startOfMonth()

As issues can be created in one period and resolved in another you might need to combine these to get what you consider the whole and the portion.

 

best of luck

/L

 

vincenzo_spatafora
Contributor
August 1, 2024

Thank You @Lisa Forstberg, appreciated that.

I will have a closer look into these JQL you mentioned.

Thanks, Vincenzo. 

vincenzo_spatafora
Contributor
August 5, 2024

Hi @Lisa Forstberg,

I don't find this "Filter counts".

Where can I find it?

As said, I use Jira DC version 9.12.5.

Thanks again, Vincenzo. 

Lisa Forstberg
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 5, 2024

Oh no, I'm terribly sorry! The filter count gadget is only on Cloud :(  

Improvement suggestion here: https://jira.atlassian.com/browse/JRASERVER-66701

/Lisa

vincenzo_spatafora
Contributor
August 5, 2024

Thanks @Lisa Forstberg

And if you come across workarounds as how to implement this gadget feature via JQL, please let me know.

I really need that.

Kind Regards,

Vincenzo.

 

Suggest an answer

Log in or Sign up to answer