Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Write complex queries

How do I find people taking longer than what the story points was estimated? 

1 answer

0 votes
Jack Brickey Community Leader Apr 27, 2022

Hi @Kaustubh Darodker ,

so story points and time are actually dissimilar. If you are using Original estimate and logging time then you can assess where things are under estimated. 

@Jack Brickey - Thanks for the quick response but we don't log time, we rely only on the story points and we roughly (and mentally) translate it to developer-hours. I am capable of writing such complex queries but I am unable to succeed with the limited capabilities of the JIRA query tool.

Jack Brickey Community Leader Apr 27, 2022

Hmmm, what does your attempt look like. I am unsure how you can query based on story points to measure the effectiveness of the story points or the individual working on the issue based on story points.

Let me give you some user stories and how one of my teams translates it to numbers

1 point - 1 day

2 points - 2/3 days

3 points - 3/4 days

5 points - 5/7 days


but what I see sometimes that a developer starts working on say a 3 pointer but then he takes over 6/7 days to finish the task. These are the kind of details I want to find. 


Say 3 points - and it started on 4/21 (or moved to in-progress) and it was marked as "done" on 4/27, which is 5 days. I want to then go and talk to the developer and check if this was an underestimation or we changed the scope and we need to be more tight with our estimation. The intent is to get these real numbers as close to the real outcome (at least) for majority of the stories. This will allow you us be more predictable to the product team and promise a roadmap that we can use as a delivery guideline, closely. 

Jack Brickey Community Leader Apr 28, 2022

where do you record actual story points?

Sorry for some I missed the notification about this question. I use the the story points field.

Suggest an answer

Log in or Sign up to answer

Community Events

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

Events near you