Hi! I don't know if this is possible but I’m looking for a simple status solution, the status of a single issue. I can see how long an issue is in a status / column; and with some research I can guess. But stakeholders would like to see a % complete.
I seem to recall a field for percent complete when I downloaded our issues to CSV but I don’t see the % complete field in our issues; apparently hidden by our administrators? Is something like this possible in Jira, or possibly in Excel?
The columns on our board are –
Hello Mike, the percentage that you mention might be related to the estimated hours and time spent on the task rather than the task status. About ways to do what you need? I would explore making it at EazyBI which allows you to build complex reports and have all in a pretty output, else Time in Status might be enough to export the information to an excel and do the math over there.
Thanks Hernán! Right now the developers aren't entering percentage complete in Jira, there are no fields to enter that; I only see that field when I export issues to CSV. Doesn't sound like this is possible in native Jira, and I also need to ask our Jira team to enable us to use that field - right?
They don't. Let's say they estimate an hour for a task on the estimated time field. Then they log 20 mins to it. There you have a progress of 33% that they didn't add but got calculated based on their input. Do you have the column name of the csv that shows percentage? I'm guessing that's the case based on the input I have
Hello @Mike Sebastian
I am not sure if you can see the complete percentage field in your issues directly in Jira, but I guess you can download the issue report and calculate what you need in excel.
With Time in Status for Jira Cloud, you can customize the columns and the statuses and later export the data as XLSX or CSV file and use it for further analysis.
If you are planning to build charts based on the data you exported, you can simply view it directly in the application by switching the grid to charts (pie/bar/area), I think this option will help you to visualize the progress you're making. You can also export chart reports.
There is a variety of reports you could generate besides simple Time in Status - Assignee Time, Average Time, Status Entrance Date, Time in Status per Date, Status Count, and Transition Count.
Hope, this will help you
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