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.
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.
Below is one of the statuses that is showing Ready for Build, but they are actually in Business Review.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
Marianne Miller
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Does anyone know if there is a way to export the percentage completed to Excel?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ian,
Does your question pertain to Jira Cloud specifically or also Jira Server?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Not sure if anyone has the answer to this in 2024? I am using Jira cloud version, how do I get a percentage complete when exporting Jira data to excel?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, I am looking for the same report.
However,I am reading the responses, and I don't understand how it could be helpful to anyone to see how many tickets are in what status. Completion of a project, assuming that the entire scope is in the JIRA and estimated is measured as % of done/total*100 - comparing that to consumed budget, you will see if you are ahead or behind...
Should we rather calculate the each tickets points estimates and work with those?
For example, I like the Sprint health gadget. I wish that there would be an option to use a "filter" with issues for that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Is there a way to see the % complete for a JIRA release? One can see % complete at an Epic level, but I am unable to see the same for a JIRA Release.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey @Ollie Guan
How did you manage to get the dashboard with pie chart showing the tasks status? I couldn't get it in my account :( Any setting required? Mind show me how? Thank you so much!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Jesling Saw ,
https://support.atlassian.com/jira-software-cloud/docs/add-and-customize-gadgets/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.