Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 19:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.

×
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

JQL calculated progress bars?

David Loszewski
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 3, 2023

Hello,

Each issue that we have is assigned a "weight" of 1-4, if an issue is difficult to resolve we assign it a 4, 1 if easy, etc.  I then have a chart on a dashboard that shows how much "weight" each user has assigned to them.   

What I'm trying to do is show a progress bar of some sort or something similar to display our capacity.   So if a user can handle a total weight of 24, and they currently have a weight of 20, I want to display that they have 83% capacity remaining.   I'll also want to display a total capacity for all team members. 

Any ideas on how I can accomplish this?  

3 answers

0 votes
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 3, 2023

Hardcore agile fans will crucify me for this, but why don't you just (ab)use the "Story points" field for this?

It accepts integers and it has dedicated support everywhere (burndown charts, velocity, backlog, board, etc.).

David Holman
Contributor
August 4, 2023

I don't see anything unsavory about that. The "weight" described is in effect effort, which is what a story point should represent. 

When I first read the question, I assumed the OP was using weight differently than points, but it seems like it would serve the same end.

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 3, 2023

Hi @David Loszewski 

Where do you want to display this information?  How would the team behave differently if you had that right now?  

Knowing those things may help the community offer suggestions of how to help.  Thanks!

Kind regards,
Bill

0 votes
David Holman
Contributor
August 3, 2023

Hopefully, there's a better solution out there but …

You could use an automation routine to calculate the utilization or remaining capacity in a custom field.

David Loszewski
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 3, 2023

Thanks! I've thought of that, the problem with Jira is there are no "Global" fields.  Fields are assigned to projects.   Ideas on where I would actually place that?

David Holman
Contributor
August 3, 2023

You can share field schemes across projects, so they're effectively global.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events