How to create a chart showing how many Jiras for a given sprint have Original Estimate empty or 0

Bijal Shah
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 18, 2024

A velocity chart was recently presented to management by a colleague.  Various teams complained that their team's velocity chart was wrong because they had not entered Original Estimates for their Jiras.


How can I show a bar graph chart by Sprints with 

- First column showing # of Jiras for given sprint (original + newly added - removed)

- Second column showing same Jiras as above, but with Original Estimate empty

- Trend line to show % of sprint Jiras that with Original Estimate empy


I am trying to get Engineering to address Jira hygiene issues before showing their performance.

2 answers

1 vote
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 18, 2024

Hello @Bijal Shah 

Welcome to the Atlassian community.

Jira does not natively provide capabilities that can satisfy your requirement. It does not provide functionality for creating completely custom charts. You would need to look at third party apps to see if there is one that could satisfy your need.

0 votes
Danut M _StonikByte_
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.
March 18, 2024

Hi @Bijal Shah,

Your request looks like a "corner case". I'm afraid that you will not find such a chart that will fully-fill your requirements. 

But something helpful could be the Team Velocity Chart gadget offered by our Great Gadgets app.  


This shows:

- Initial Scope - the total Original Estimate at the start of sprint

- Final Scope - the total Original Estimate at the end of sprint  (original + newly added - removed)

Optionally you can choose to display bars for Added, Removed, % Added, %Removed, etc. 

It can also display a data tab, showing the issues that had empty or zero Original Estimate at the start of sprint.

You can easily export this data in CSV and do further processing in Excel if you want.

Hope this helps.


Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events