nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL to sum story estimates/time to Epic?

Kim P

My JQL skills are a bit limited but I'm needing to run a query/report that will sum ALL stories for an Epic of a project, where the Epic is "In Progress" status. The report would need to show the current sum of ALL stories Original Estimates and Time spent. We are using Tempo for time logging on issues and also have the ScriptRunner add on but no other reporting add ons. Is there a way to get this data without the use of another paid add on? Can anyone help me to write a query?

Imagine something like the below.......

Project A

Forecast Hours(our custom field) Original Estimate Time Spent

Epic 1(has 3 stories) 45 60 25

Epic 2(has 4 stories) 30 35 2

Accepted answers

All comments

Jack Brickey

Hi Kim, JQL wouldn't apply for your needs. I might suggest a free lite add on - Epic Sum Up Light or get the paid version for more capabilities.

Jack Brickey

or you could consider creating a custom field and use automation to update anytime an underlying story changes.

Kim P

Thanks! I tried sum up light and it doesn't give us anything useful as from what I see it's just a progress bar on the individual Epic. We can't run any filters for it and it's not project specific. Unfortunately I've got no money for an add-on. We've tried the custom field route and can't get it to work properly, this was with the help of Atlassian. I'm sure there's other folks in need of the same metrics and can't imagine everyone pays for an add-on to get the data. Will keep looking for alternative.

Jack Brickey

cool. if you find a solution that works be sure to capture here. cheers!

Shaili_RVS_Support

HI @Kim P

If you would be interested in a paid add-on, you can try out our app

Agile Tools : Epic Tree & Time in Status

The app provides you complete Epic Hierarchy for a project with progress at each level. You can view/manage roll up for standard Jira hierarchy. Epic -> User Story -> Subtask for both rime estimates and story points

The app also provides Dashboard gadgets for this data.

Epic Hierarchy.PNG

Kim P

As per my initial request it specifically asks "Is there a way to get this data without the use of another paid add on?". No money for ANOTHER add on.

lucashm

issue in childIssuesOf (XX-XXXX) AND issueFunction in aggregateExpression ( Sum Time Spent, "timeSpent.sum()")

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud