Epic not summing time logged in Tasks/SubTasks

[Maureen Gilchrist]

Hi Community!

I am seeing what I think are some inconsistencies in how time is logged at the Epic level.

In List view....I've singled out one Epic which has an Original Time Estimate and has 2 Tasks both with Time Logged - but the Epic shows No Time Logged. 

So I ran a time tracking report and I see the same - Original Time Estimate on Epic line item but no time logged against the epic.

SO I checked another EPIC with multiple Tasks - Epic and most Tasks have Orig Time Estimates, most have time spent but Epic is not reconciling and adding tasks up to that Epic level (EPIC has its own OTE and time spent).

Anyone know how to set up my project where the Epic will summarize the OTE/Time Spent for all its 'child' Tasks and Subtasks?  So I can say "for x customer project we estimated abc minutes and worked xyz minutes"

Thanks!

[Dave Mathijs]

Hi @Maureen Gilchrist 

The Time spent on standard issue types is not rolled up to the Epic level, you'll only be able to fill out time spent on the Epic issue directly.

However, the Time spent on on sub-task issue types IS rolled up to the standard/base issue types.

There are paid third-party apps available on the Atlassian Marketplace that let you roll-up time spent up to Epic level.

[Maureen Gilchrist]

@Dave Mathijs  thank you for this info.

I had tested a few 3rd party apps months ago trying to get better time tracking and didn't find one that I liked for what we need.  If you have any suggestions I would appreciate - I can test them to try if I haven't already!

[Rahul_RVS]

Hi @Maureen Gilchrist 

If you are fine with a mktplace app, you can try out our add-on.

Issue Hierarchy Reports 

The app will certainly show you the data as per you need but in a tree view.

You can generate insights such as below a:

- View the full Jira Issue Type hierarchy of Linked issues,
Portfolio/Advanced Roadmaps, Epics, and Subtasks up to 10 levels.

- % complete based on time spent and story points at each hierarchy level

- Sum up Time Spent, Org Estimate, Time Rmng, custom number
fields

- Epic Hierarchy on Issue Screen

Disclaimer : I work for the vendor who built this app

[Maureen Gilchrist]

Thanks I'll check it out - seems I will need a 3rd party to do what we want to do so appreciate the lead!

[Maureen Gilchrist]

@Dave Mathijs Hi Dave - curious follow up question

one of my architects set up his Jira with Epic -> multiple tasks -> and those tasks have subtasks.

And it seems the EPIC is showing the rollup of all the time logged in the subtasks at the Epic level - is this a loophole my Architect has identified?  Or expected behavior?

Meaning - could I have my team use this three tiered setup always and get the needed rollup at the EPIC level?

I appreciate your insights!

Maureen

[andre]

Is there a chance to solve this using automation, without double booking? 

[Dan -minware-]

Disclaimer: marketplace partner

Hey @andre - if you are open to working with a 3rd party this is something we can help with at minware. 

[Dan -minware-]

Disclaimer: marketplace partner

Hey @Maureen Gilchrist - want to throw our name in the mix here for 3rd party services (minware). We just do this "out of the box" and we can automatically calculate time for tasks that don't have any work logged against them:

[Svitlana Samotis _Reliex_]

Hi Maureen, 

I'd like to recommend our add-on, ActivityTimeline, as a solution to help you reach your goal.

It will give you a flexibility to choose between a granular view of all worklog records and summed up time spent on epic and all subtasks: 

And a high-level overview report to suit your needs and answer the question you are looking to answer: "for x customer project we estimated abc minutes and worked xyz minutes": 

Check it out and see if it could be of assistance to you.

Regards, 

Svitlana

Reliex team  

[Maureen Gilchrist]

Thank you I will - appreciate the lead, will give it a look!

[Hannes Obweger - JXL for Jira]

Hi @Maureen Gilchrist

I don't know if you already came across it, but I believe your use case would be quite easy to solve with the app that my team is working on, JXL for Jira.

XL is a full-fledged spreadsheet/table view that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping, and sum-ups. With these features, you can roll-up pretty much any fields across any issue hierarchy, e.g. like so:

Any questions just let me know,

Best,

Hannes

[Maureen Gilchrist]

Thank you I will give it a look - I've a few recommended here which I appreciate!