Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

Can not get the sum of time spent for an Epic

I have one epic which has some stories as its child. but when I enter log work for any of those stories and I query the epic the time spent field is empty. How can I see the logged works of an epic?

5 answers

It sounds like a bug to me.

I agree with MDA. It's never made sense to me why the "Sum of Time Spent" for an Epic doesn't aggregate from Stories/Tasks (and Subtasks) lower in the hierarchy.

If I wanted to know how much time has been logged to an Epic (and only the Epic issue), then the "Time Spent" value gives me that. For other issue types, the "Sum of Time Spent" aggregates any time logged to "child issues" -- but not for Epics. So frustrating!

Try this in your Jira instance: search issues with JQL "type=Epic and (timespent != 0 or remainingEstimate != 0)", and use these columns in the result:

  • Time Spent
  • Sum of Time Spent
  • Remaining Estimate
  • Sum of Remaining Estimate

You will see that the first two ALWAYS match, and the second two ALWAYS match.

(For bonus points, search instead for "type=Story" and add "order by subtasks". You'll see how the Sum fields *do* aggregate properly for Stories with Subtasks).

In my opinion these two "Sum" totals for Epics have been BROKEN in Jira for a long time.

P.S. I do NOT want to hear about third-party add-ons to "fix" this. This is built-in functionality to Jira that does not work properly.

0 votes
Nir Haimov Community Leader Apr 10, 2019

Hi,

In your JQL, add this column "Σ Time Spent", this wall show you the logged time for epic

No, my "Σ Time Spent" is empty 

Nir Haimov Community Leader Apr 17, 2019

You can see it boards, in Epic panel, if your board estimation set to show in time estimation and not story point, you will your sum for epic there.

If you want to see it by JQL or something else, you will have to use 3rd party plugin

Like Amin Memariani likes this

In the mean time (until Epics show accurate Sigma Time Spent and not just Time Spent), let's do this.  Run JQL Reports without Epics and show the Sigma Time Spent Column in your Columns as well as the Epic Link field.  Then Group by Epic Link and add up the Sigma Time Spent Entries by "Epic Link". 

 

That is what I need to do for a Report I am working on today.

Hi

You can try out our add-on to track progress of issues in Epic hierarchy on time estimates and at story points as well.

Agile Tools - Epic Tree and Time in Status 

The add-on allows you to manage and visualize your Epics with rolled up estimate progress reports along with multiple Time in Status Reports ( more than 6 reports).

Key features of Epic Hierarchy:

    • Epic Sum up - Roll up for Time estimates and Story Points
    • Excel like editing for key fields
    • Excel export of hierarchy dataProgress % on "remaining estimate" or "original estimates"
    • Include all issue types vs only Stories in Story Points roll up
    • Support for custom names for Epic & Story fields
    • Epic Tree on Issue Screen

Epic Hierarchy Screen_Cloud_Latest.PNG

Suggest an answer

Log in or Sign up to answer
TAGS

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