Sum of Estimated time on Epics

[Randy Howk]

I have not broken up the project into sprints, I just want a sum of the estimated time I have entered for each story, preferably by Epic. No work has been logged yet, just want an idea of the time estimated for the entire project.

[Igors_Veliks]

You can see that in Backlog view when you open Epic:

[Paweł Lewiński]

It's sth I also need. Is this the sum up of all stories inside epic or just epic estimation itself?

[Igors_Veliks]

It is the sum-up of all stories inside epic

[Mike Kondrashin]

@Igors_Veliks i think that's only the epic itself

[Igors_Veliks]

@Mike Kondrashin nope

[Mike Kondrashin]

@Igors_Veliks I see, it does sum up tasks in the backlog, but not including sub-tasks...

[Igors_Veliks]

Right, it does no take sub-tasks into account

[Ben Upham]

@Igors_Veliks Is that custom code? Or does the project have to be of a certain type? I don't see those estimate totals in my Epics backlog.

[Igors_Veliks]

@Ben Upham no, this is not custom code. You might just need to enable estimations in settings.

Worth to mention, that I'm using Cloud version.

[Ben Upham]

I think that may be for Scrum boards only. We're using Kanban...thanks for the reply.

[Rahul_RVS]

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 data. Progress % 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

Along with Epic Sum, you also get Links Hierarchy and Multiple Time in Status reports (to track your issues) in this add-on.

[Shannon S]

Hello @Rahul_RVS,

Thank you for sharing your company's add-on to this thread. However, please be aware of our Community Guidelines for vendors stance on necroposting:

A word on necroposting: Aka, "raising threads from the dead." In general, avoid posting on old threads (six months or more old) simply to promote your products. However, you may post on old threads in certain cases.

Refer to Revisiting our necroposting guidelines for more details after you've read the article above.

Thank you for your understanding.

Shannon

[Steffen Stamprath]

I think the plugin "Epic Sum Up" is exactly what you need!
https://marketplace.atlassian.com/plugins/aptis.plugins.epicSumUp

[Ansar Rezaei]

Hi

thanks for your plugin and I see it. But I need sum of Original Estimate in order to use it with BigPicture Gantt Plugin. Do you have any solution in order to copy the aggregated time to Original Estimate field s of Epics?

[Stine Søndergaard]

Hey @Ansar Rezaei ,

Did you ever find a solution to this? I have the same issue with BigGantt ...

/Stine 

[Lisa Reilly]

There's a free plugin called SumUp which shows you the total days for any filter results.

So you can just search for "project = [project name]" and the totals for each column in your filter results will show up at the bottom.

Even if you have more than 100 results, say you have 500 tasks in your project, the total for the 500 tasks will show at the bottom of the screen. Below is an example for one of my projects, showing originial estimate, remaining estimate and time spent:

https://marketplace.atlassian.com/plugins/com.atlassian.cps.sumUp

[Igors_Veliks]

It's not free anymore:

 

[Ron LaJoie]

Really old thread but it appears people still stumble upon it from time to time.

The easiest way to get this info quickly, at least for me, is to create a filter with just the epic I want total time for (including all the sub-tasks), and then do a Workload Pie Chart Report using that filter and original estimate.  Boom!

[Anna-BigPicture]

Hi Stine,

I will assume that by "the total OE on epics" you mean the sum of all OE of The Epics children as if they were done one by one continuously and that by "the length in the Gantt chart will be accurate" you mean that the length of the parent Epics' taskbars would reflect this sum up.

Steps to follow:

• Point 1 from my previous answer
• Then map the End date of your tasks to OE
  Unable to render embedded object: File (Caution) not found. Please note that changing the task mapping should be done after careful consideration as the changes cannot be undone. In this case, I mean particularly the OE which could be overwritten unintentionally by too quick clicking and the suggestion to change the mapping per Project rather than globally for the plugin. See the image below:
  this step WITHOUT MIGRATING EXISTING VALUES TO NEWLY SELECTED FIELDS will cause the plugin to take OE as the End of the taskbars representing the issues on the Gantt timeline. Potentially, if your project consists of many tasks, your Jira instance might be slowing down due to a large number of custom fields being migrated if you leave the default switch enabled.
  
• Then Link the child stories with ASAP links to get them in consecutive order. Once again, please note the Start and End dates of the linked Stories WILL change.
• Make sure the task mode of the Parent Epic is "Auto Bottom-up". This will effectively extend the length of the parent Epic taskbar to cover the child stories.
• observe the results on Gantt:
  

Anna od SoftwarePlant

[Radosław (SoftwarePlant)]

Hi Randy,

BigGantt or BigPicture are the perfect tools to use for your report.

Follow these steps to get your OE nicely aggregated on the WBS:

1. Assuming you already have the Epics and the stories in your program you now need to build your WBS using Epic Structure builders(or indent your stories under Epics manually):
   2. now you need to add the Original Estimate to your Column views and set the aggregation to "Sum no Parent" to have the sum of child Stories shown on the Epic.(You may choose other aggregation types as well):
   3. All that's left now is to navigate back to your Gantt and enjoy the nice Gantt report presenting you Epic Summ up of OE on the stories in Each Epic:
   
   If you do not care about the timeline but just want the report, I suggest using the Scope module which you set up in a similar fashion but can build more comprehensive reports by combining multiple columns into one report:
   
   
   I hope it helps.
   
   Radosław SoftwarePlant

[Stine Søndergaard]

Hey @Radosław (SoftwarePlant) ,

How can I use BigGantt to sum up the total OE on epics so that the length in the Gantt chart will be accurate? Currently I can only do this by manually adding an estimate to the epic. 

/Stine

[Stine Søndergaard]

Hey @Radosław (SoftwarePlant) ,

I can see in my email that you answered, but the answer is not here?

/Stine

[matuella]

You guys should take a look at this awesome free plugin - it did fit all my needs

[Rhys Diab _Agile Docs_]

Hi Randy,

You can use Agile Docs to sum up the total estimated time of each Epic in your project.

Opens up right inside your project dashboard.

 Or, if you want a zoomed-out view of Epics only, you can uncheck "Expand All Epics”:

If you need a more granular way to search for Epics rather than just all unresolved Epics in your Project, you can use your existing Quick Filters to search for them.

Hope that helps!

[George Mihailoff]

First of all, what if you don't need to deal with manual work logging anymore!?

Check out the Quantify time spent addon. And yes, it can sum up tickets in epics including sub-tasks.

[Souni Breil]

@Igors_Veliks how did you get to the view  in your screenshot please? :D

[Igors_Veliks]

@Souni Breil wrong thread, but anyway: it's jira cloud + scrum board + backlog view

[jira1]

I need a help please!
i need a generic groovy script for Total!! estimate on an epic in JIRA, including childes (issues & sub tusk)

i know there is an add-one but ineed only a working groovy script.

thx 

[Randy Howk]

In RapidBoard I see the totals per epic, still would be nice to see grand totals, but a spreadsheet worked for now.