Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Time spent on at Epic level

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 

8 answers

you can do that:

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

0 votes
John Funk Community Leader Nov 16, 2021

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.

0 votes

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. Agile-Docs-Estimate-Tree-Jira.png

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

Hope that helps!

0 votes
Anna-BigPicture Marketplace Partner Apr 28, 2021

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. 

image - 2021-04-28T150609.348.png

0 votes
Bloompeak Support Marketplace Partner Apr 25, 2021

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.

0 votes
Rahul_RVS_Support Marketplace Partner Apr 19, 2021

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


Epic Hierarchy Screen_Cloud_Latest.PNG


0 votes
yuliia_b__SaaSJet_ Marketplace Partner Apr 16, 2021

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.


0 votes
Trudy Claspill Community Leader Apr 15, 2021

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

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.

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events