Time spent on at Epic level

[Prasad Kulkerni]

We have Tasks under an Epic and time is tracking at Tasks level. At Epic level how can I get sum of time spent on Tasks level 

[lucashm]

you can do that:

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

[John Funk]

Hi @Prasad Kulkerni  - not sure if you ever got this solved or not. But here is an article that should help walk you through a solution using Automation for Jira.

https://community.atlassian.com/t5/Automation-articles/How-to-sum-up-logged-hours-using-automation-in-Jira-Cloud/ba-p/1409115

[Rhys Diab _Agile Docs_]

Hi @Prasad Kulkerni 

As mentioned above there are number of apps which can do this.

Our app Agile Docs can do this for you in a couple of way.

You can view a report of the rolled up time logged for each Epic directly in the app while seeing the time logged against your entire hierarchy. 

You can also set the total time logged to display directly inside your Epics.

Hope that helps!

[Anna-BigPicture]

Hi @Prasad Kulkerni

Please have a look at BigPicture/BigGantt. It seems to be a good match! The plugin displays and aggregates data not only on a single task & epic level but also on a project or its phases level.  The plugin gives you the possibility to aggregate data of statuses, progress, and time tracking. 

[Bloompeak Support]

Hi @Prasad Kulkerni ,

It is not possible out-of-the-box in JQL. You can calculate it by coding which parses issue history rest api json for each issue. Or you can search for marketplace apps which does the same for you.

As an alternative, you can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports(eg. average in progress time per project). And all these are available as gadgets on the dashboard too.

Here is the online demo link, you can see it in action and try.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.

[Rahul_RVS_Support]

Hi @Prasad Kulkerni 

You may want to try out our plugin, Agile Tools : Epic Tree & Time in Status 

The app provides roll up for time estimates fields for an Epic in a hierarchy.

It provides 3 major functionalities in one add-on

• Epic Sum up (standard Jira 3 level hierarchy)
• Link Hierarchy (upto 10 levels ) of Hierarchy and their rolled up sum for time estimates and Story Points
• Time in Status Reports
  • Time in Status
  • Time with Assignee
  • Time in Status with Assignee
  • Time with Assignee per Status
  • Status/Assignee Count
  • Multiple Transition Reports

[yuliia_b__SaaSJet_]

Hi @Prasad Kulkerni 

As an option, you can try Time in Status for Jira Cloud add-on (developed by my team). For more information please read here: 

How to get time in status data by Epics?

Hope you find the best solution for you.

Regards

[Trudy Claspill]

Hello @Prasad Kulkerni 

Welcome to the community.

Summing up time spent to a parent epic is not a built in feature for JIRA Cloud.

You could look at using an app to get that information separately. For instance we use Worklogs - Time Tracking and Reporting

With that tool we  use filters to collect all the time tracking information and then create a Worklogs dashboard that summarizes the information by epic.

There are other apps that can provide sum up functionality too, like this one

https://marketplace.atlassian.com/apps/1220287/epictime-for-jira-sum-of-worklogs?hosting=cloud&tab=overview

I've never used that one so I can't say how well it works. And I'm sure there are others.

I am sure that you could also create a custom solution where you define a custom number field in the Epic and then maybe use Automation to update that field each time somebody logs time against a child issue.