How to create a % of Done view for a Sprint

[Mirmelshtein_ Roi]

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

[Bill Sheboy · Accepted solution]

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

[Danut M _StonikByte_]

Hi @Mirmelshtein_ Roi,

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

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:

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]

Hi @Danut M _StonikByte_ 

This is great !!!

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

Roi

[Danut M _StonikByte_]

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]

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?

[Bill Sheboy]

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.

[abhishek_sharma03]

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]

Hi @abhishek_sharma03 

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