Use Story Point Estimates to identify 'at risk' issues

[Calahan Larson]

I am trying to use JQL queries to compare the time that a ticket has been 'active' against its story point estimate. Is this possible with OTB JIRA?

I would like to quickly identify issues that haven't been updated within a certain amount of time relative to their point estimate.

[Kristján Geir Mathiesen · Accepted solution]

Hi @Calahan Larson and welcome to the Community

You will need to use Atlassian Analytics (which is in Beta now) in order to find out how long a ticket has been in a certain status or a 3rd party app. It is not possible with OTB Jira JQL search/filter.

HTH,
KGM

[Maksym Babenko_TypeSwitch_]

Hello @Calahan Larson 

Yes, you can achieve this in Jira using JQL, though it has some limitations. Jira doesn't support direct calculations with Story Points, but you can use JQL to filter issues based on their last updated time and Story Point values.

A basic JQL query to find issues that haven't been updated in a while could look like this:

storyPoints >= 5 AND updated <= -7d

This finds issues with 5+ Story Points that haven't been updated in the last 7 days.

For a more advanced solution, you might need Jira Automation or a third-party app like Risk Radar for Jira, which helps identify high-risk issues based on multiple factors, including inactivity and complexity. 

[Meghan LaClair]

Hi @Calahan Larson 

There isn't a native option for this at the moment, but if you are open to 3rd party solutions we have solved for this at minware. We combine Jira ticketing, code sources, and calendar data to provide a global view of the entire SDLC. 

Our Sprint Insights report includes a time estimate analysis. We calculate velocity at the task level so that you and your team can understand where your estimates are falling short, and improve your process. 

We also provide notifications based on your organizations settings, so that tickets that are behind schedule are automatically pulled out and flagged. This helps you dig in and help remove bottlenecks. 

We offer a free trial, let me know if you would like to check it out! 

Disclaimer: Atlassian Marketplace Partner