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

How to sum up logged work


Hi together,

is there any way to consolidate spent time in an epic.

1st Problem

I tried to branch the automation by using For epic (parent) and inserted "{{issue.subtasks.aggregatetimespent.sum}}" but that always reply 0. Even if I see by using the Rest Api that there is a value in it.

2nd Problem

Even if I have the summarized time spent. Where to store it? I want to have it visible in the time tracking field available in my epic.


So I want to realize by automation the checkbox Jira introduced for standard issue types "Including Subtasks" but here as "Including standard issue types"


//edit 02.11.2021

I tried even more potential smart values, and all reply "0". I tried it now with the action Lookup issues, and for Story Point sum it works.


All reply 0:






2 answers

This really helped me to get time spent of sub-task under lookup value in Automation


{{issue.subtasks.timetracking.timeSpentSeconds.sum}}    <<< For sub-task Time Spent

{{worklog.timeSpentSeconds.sum}}    << for task Time Spent


Adding both I got rollup at Task which is similar to Aggregate (Sigma) Time Spent 

I found a solution but it's quite hacky.


I use the action "Send web request" with the following values:

.../rest/api/latest/search?jql=%22Epic+Link%22%3D{{issue.epic link}}&fields=aggregatetimespent


  • Field1: Authorization
  • Field2: Basic (you must encode as base64 string)

HTTP method: GET

Web request body: empty

Wait for response:

  •  Delay execution of subsequent rule actions until we've received a response for this web request -> "check"
  • Continue running the rule even if the request response is not successful (i.e. non-200 response) -> "false"


After a successful request you can use the following statement to sum up all aggregates timespent of standard issue types except epic. So it's only working for items like story, bug, ...) But that's no problem because you can check include subtasks in the standard issue type and then the value is included in aggregatetimespent.



Quite hacky and sadly you need login credentials from a user for that. But I didn't found any other way, because I can't access aggregatetimespent by smart value.

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Nov 02, 2021

Hi @Denis 

The Lookup Issues action only supports a small number of fields currently, and does not support those time tracking fields.  I believe using the REST API is one of the only ways to do this currently from within a rule.

The other way is to trigger on child issue changes for the fields, adjusting custom fields in parents with each change.

Kind regards,

Like Denis likes this

Thanks for you answer, Bill. :)

Then I will go with the rest api.

Thanks for sharing @Denis -- between your info and this page:

I was able to get it working for multiple custom fields on the Task issues that I wanted to roll up to the Epics.

Like Denis likes this

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events