It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Is there a way to report percentage of completion for stories in a project?

I am a QA tester and we use Jira boards for our projects. Once the story has made it through testing we put it in the Done column. My boss also has us export all of the stories to excel and update the status there plus calculate the percentage of completion. There has be some kind of report in Jira to do this, right?? I hate that I have to keep two places update and also send a stupid status report. 

Please tell me there is a way to report on our status without downloading to excel. 

2 answers

1 accepted

0 votes
Answer accepted

There absolutely is!  You should build an Issue Filter for your current Sprint (Active Sprint) and add the Issue Statistics gadget to a Dashboard.  You will see a breakdown by status with percentages.

sprint.png 

The first thing you need to do is buld a query for your search results.  A basic one would be 

project = XXX AND Sprint in openSprints().  This will give you your Active Sprint in XXX= your project.  Save this with a unique name.  If you are only looking for specific status, you can add those to the query to filter out everything but your "done" statuses, eg.  make sure you share this filter.

The create a Dashboard.  There are so many gadgets you can add to tell this story, but for the down and dirty, I'd recommend this one - Issue Statistics.

Go to Dashboards, => Manage Dashboards

Select Create a New Dashboard

Fill out the required information and make sure to share Viewers and editors as appropriate.

Go to your new Dashboard and select Add Gadget at the top.  The original set may be limited, so click the Load all gadgets option at the top.

Type in issue Statistics and then the Add gadget button.  Close the tool

On your board, the gadget will appear on config mode. Choose the name of the filter you created, then change the statistic type to Status. 

With that simple setup, you have just what you need to report your completion percent and so much more.  I think you'll find lots of great gadgets to add that will really help you.

 

Good luck!!

Thank you so much for this! This is exactly what I needed!

One more question....We have a column on our board called Business Review, but in the actual story the Status is Ready for Build. I need a way to show the column heading instead. Is this possible? Our scrum master said she can't rename the statuses. 

image.png

Below is one of the statuses that is showing Ready for Build, but they are actually in Business Review. 

image.png

If I understand you correctly, you are trying to report on a status that does not exist in your workflow, right?  The column heading on the boards is arbitrary - you can name them whatever you like, but they're not reportable.  Think of them as buckets for different statuses in your workflow.  you can't display this column name in the status field on your story

You can rename statuses, but it will apply across the board anywhere it ist is used in a Workflow, not just to one story.  That may impact other projects.  If you have the use case for it, you may be able to add this status as a new status and add the right transitions so that you can update your storie(s)

workflow.gif

Your Scrum master may or may not have these permissions depending on your organizations' policies, but someone should have some options for you.

 

Hope this helps,

 

Marianne Miller

Thanks Marianne! Do you have the navigation to transitions?

Marianne Miller Community Leader Sep 10, 2019

This is the way I find easiest :

In the Jira Admin tool, go to your Project.

Navigate to Workflows

use the pencil icon (under Actions) to edit

You can edit existing or add a new step to the workflow here

0 votes

Hi  @Kathy Cave ,

It seems that the Pie Chart in Dashboard can match your case.

TIM截图20190829110254.png

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

275 views 1 2
Join discussion

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