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.
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.
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.
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.
Below is one of the statuses that is showing Ready for Build, but they are actually in Business Review.
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)
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,
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