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

Can someone assist in building a filter?

I need a filter that will allow me to see per user a summary of Estimated and Actual Hours by Sprint.  The data is all in JIRA, but I need an easy way to pull this for pre and post sprint activities.

Thanks is advance for all of your assistance.

1 answer

0 votes
Moses Thomas Community Leader Jun 07, 2021

@Andrea Brown  If you have the script runner plugin for JIRA,  you could do something like this 

project = "ABC" and issueFunction in aggregateExpression("Total Estimate for all Issues", "originalEstimate.sum()", "Remaining work", "remainingEstimate.sum()") AND Sprint in openSprints()  AND assignee = currentUser()

We also have function like closedSprints(), futureSprints()  for usage. In aggregate expression you can also use  timespent.sum() ;  total time spent on all issues.

I hope it helps

Kind regards,


Suggest an answer

Log in or Sign up to answer

Atlassian Community Events