Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Visibility to issues with recently updated story points

Kate I'm New Here Dec 14, 2021

How can I see a list of issues in a project with recently updated story points? I'm fine amending a report, dashboard widget, or using issue search with JQL, just can't quite get to what I need, which is visibility to how many points we add to our backlog each week (which is not the same as the number of issues we add to the backlog).



1 answer

0 votes
Mykenna Cepek Community Leader Dec 15, 2021

I'm not aware of anything in the standard product that will total the Story Points in the backlog.

Maybe there's a Marketplace App that could help with this; I can't advise on that.

It would be helpful to know if you're wanting to do this for Company-Managed Project, Team-Managed Projects, or both.

_ _ _

A simple, but manual, approach would be to have a saved Filter to generate a list of all issues in the backlog, import into Excel, and sum the Story Points column manually. Not pretty, but would only take a few minutes once each week to do manually.

_ _ _

You could also explore Jira Automation as an option to help with this. There are some tricky points, but it might work for your use-case.

Ideally, this rule would compute the Story Point total in your Backlog, and can even email it to you weekly (or daily!), or send via a Slack or Teams message.

However, creating this rule will have a few tricky spots to work out...

One is exactly how to detect an "issue in the Backlog". Sounds trivial. But it actually differs between Scrum and Kanban board in Jira. Issues tracked on Scrum boards are in the Backlog when the Sprint field does not contain an open sprint value. Issues tracked on Kanban board are in the Backlog based on the Status field.

Another tricky aspect is handling the likely large number of issues in your backlog. If it's under 100, you're golden. More likely you have over 100 issues in your Backlog, and this will add some complexity to the rule. This is because the Issue Lookup feature has a limit of 100 results. 

The magic here would be to use something like this:

{{lookupIssues.Story Points.sum}}

to create partial sums (of 100 issues or less), and then add all those together. Note that this cannot currently be done in a loop in automation.

If you want to explore this approach, I recommend posting a new question focusing on Automation -- something like "Automation to sum Backlog Story Points".

Suggest an answer

Log in or Sign up to answer
Site Admin

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