How to create a % of Done view for a Sprint

Mirmelshtein_ Roi July 10, 2023

Hi Guys

I'd like to create a pie chart or any other visual that displays the % of done for specific filter...but I'm stuck in creating a filter first to show me only the resolution = done issues in specific sprint in specific project 

Does anyone have an idea how to do that?

Roi

3 answers

1 accepted

0 votes
Answer accepted
Bill Sheboy
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.
July 10, 2023

Hi @Mirmelshtein_ Roi 

Have you tried using the built-in pie chart for this, with a filter for just your issues, and displaying Resolution?  When you select an area of the pie chart it would show the percentage for that section.

An example filter as you describe could be the following, substituting in your values:

project = myProjectName AND sprint = yourSprintName

You could also make this generic to handle the current, open sprint as follows:

project = myProjectName AND sprint IN openSprints()

Kind regards,
Bill

0 votes
Danut M _StonikByte_
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.
July 10, 2023

Hi @Mirmelshtein_ Roi,

You can easily do this with the Advanced Issue Filter Formula gadget offered by our Great Gadgets app.

image.png

All you have to do is to: 1) create a filter that returns all the issues from sprint; 2) Create a filter that returns all the issues resolved in the sprint 3). Configure the gadget to use the filters and apply the appropriate math formulas, as in this picture: image.png

This app offers many other gadgets that you might like.  If you need any help, please contact us at support@stonikbyte.com.

Regards,

Danut M.

Mirmelshtein_ Roi July 13, 2023

Hi @Danut M _StonikByte_ 

This is great !!!

But we don't use story field...so which filed do I choose?

Roi

Danut M _StonikByte_
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.
July 13, 2023

Hi @Mirmelshtein_ Roi

You can configure the gadget to calculate by issue COUNT instead of SUM of Story Points.

It support also time estimates fields or other numerical fields.

Danut.

Mirmelshtein_ Roi July 13, 2023

that works only our issues are migrating from sprint to sprint (like the below) and I can't figure out how to create a filter that will see only the issues that were in Q03S4 or only the issues that were resolved in Q03S4 - as the sprint report shows once you close a sprint - any idea how to do this?

Capture.PNG

Bill Sheboy
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.
July 13, 2023

Adding to Danut's answer...

@Mirmelshtein_ Roi -- It now seems that you are asking for the % Completed for different sprints over time, and not for just one sprint.

If that is correct, another gadget in the same addon Danut describes does that: the Team Velocity Gadget.  With that, you may select to show just the % Completed for the different sprints over time.  https://bitbucket.org/StonikByte/great-gadgets-add-on/wiki/Home#!team-velocity-gadget

Please note: I am not associated with Danut's company StonikByte.  Instead we use that addon with our Jira instance.

Like Danut M _StonikByte_ likes this
0 votes
abhishek_sharma03
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.
July 10, 2023

Hi @Mirmelshtein_ Roi - I am afraid this kind of report/view is not available out of the box. However can be achieved by marketplace addons.

BR

Abhishek

Mirmelshtein_ Roi July 10, 2023

Hi @abhishek_sharma03 

Understood thanks. What about the filter? Can I create just the filter which will provide the above?

Suggest an answer

Log in or Sign up to answer