How to calculate total time spent on stories,bugs and adding it to related Epic using Automations

Vineela Durbha

Hi team,

We have stories/Bugs and there is time spent on each one . We need to import to the epic the time that are logged in the tasks (stories, bugs and spike) that are connected as "is parent task of" in the project.

We are looking to achieve this using automation rules and hence looking for some guidance on the same.

 I am trying something as below  but looks like its not working

 

Anahit Sukiasyan

hi @Vineela Durbha

Yes you can achieve that by creating an Automation Rule, hope these steps will be helpful:

1. Create a New Rule.

2. Set the Trigger:

   • Select the Issue Updated trigger.
   • Configure the trigger to run when Time Spent is logged or updated.

3. Branch Rule/Related Issues:

   • Add a branch for Parent Issue to target the Epic.
   • This branch ensures that changes in time spent on child issues (stories, bugs, etc.) are reflected in the Epic.

4. Action: Sum the Time Spent:

   • Inside the Parent Issue branch, add the Edit Issue action.
   • Set the Time Spent field of the parent Epic by summing up the logged time from child issues.
   • Use this smart value for summing:
     {{issue.subtasks.timeSpent.sum}}
   • If you are not using subtasks but rather linked issues (e.g., "is parent task of"), use:
     {{lookupIssues.timeSpent.sum}}

5. Fetch Related Issues (if using links):

   • Add a Lookup Issues action before editing the Epic.
   • Set the JQL to fetch linked issues:
     issue in linkedIssues({{issue.key}}, "is parent task of")