Seeking Automation Solution for Aggregating Time in Epics

[Ahmed Saci]

Hello Atlassian Community,

I am reaching out for assistance with a specific use case related to time management in Jira (or the relevant software). We have implemented a system where the time spent on sub-tasks is logged and automatically aggregated into the parent tasks using an existing feature. However, we face a challenge: this aggregated time does not automatically reflect in the corresponding Epics.

Our goal is to develop an automation that can accumulate the total time spent on all tasks within an Epic. Here is our current process:

1-Time Logging: Time is logged at the sub-task level.
2-Aggregation in Parent Tasks: An existing feature automatically aggregates this time in the parent tasks.
3-Issue: This aggregation does not extend to the Epics, which is crucial for our project tracking.
Would anyone have encountered a similar problem or have an idea on how to implement such functionality? Specifically, if anyone has successfully developed an automation for this use case using Jira automation, Jira Misc Workflow Extensions (JMWE), or Power Scripts, your insights would be invaluable.

Any help or suggestion would be greatly appreciated.

Thank you for your time and assistance.

Best regards,

Reda

[Trudy Claspill]

Hello @Ahmed Saci 

What existing feature are you using to aggregate sub-task time at the parent issue level? Is it this?

If so, that aggregates the time in the display only. It is not actually storing the sub-task time logged within the parent issue. It is dynamically adding up the sub-task time to show it to you within the display of the parent issue. In that case your solution would need to involve gathering the time logged against sub-tasks also.

There are numerous posts about summing up time logged from child issues to their parent Epic. It can be done with Jira Automation or with third party apps. Here are a few posts:

https://community.atlassian.com/t5/Jira-questions/how-to-show-total-tracking-time-of-all-tasks-in-Epic/qaq-p/2362843#U2364321

You may also find that somebody has shared a solution in the Jira Automation Template Library (which can be accessed from the Automation page Templates tab).

https://www.atlassian.com/software/jira/automation-template-library#/rule-list?systemLabelId=all&page=1&pageSize=20&sortKey=name&sortOrder=ASC