To sum up Original Estimate / Time Spent on Epic level - Automation

[Oksana Kolesnyk]

Hello. 

I am trying to set up Jira automation to calculate the total Original Estimate / Time Spent on an Epic, including child issues. 

But each time, I get an error notification on different steps.

The last branch I tried with values: 

- {{#=}}{{lookupIssues.timeSpent.sum}} + {{issue.timeSpent}} / 3600{{/}}

- {{#=}}{{lookupIssues.time spent.sum}} / 3600 {{/}}

Please, someone, help me set it up.

Also, how to use:

- Σ Original Estimate
- Σ Remaining Estimate
- Σ Time Spent

In automations, I do not have the possibility to choose these fields.

Thanks 

[Marc - Devoteam]

Hi @Oksana Kolesnyk 

Welcome to the community.

On your second rule, set the branch value to {{lookupIssues}}, as I do think you want to action on each Epic found, correct?

Time tracking has 1 smart values and 2 properties to be used:

{{issue.timetracking}}
Accesses time tracking estimates.

Available properties:

1. {{issue.timetracking.timespent}} - Returns the amount of time that has been logged on the issue in the Time spent field.
2. {{issue.timetracking.remainingestimate}} - Returns the value in the Time remaining field.

See also this community post, or search the community. This question has been covered more then once.

https://community.atlassian.com/forums/Automation-questions/Jira-automation-rule-to-sum-up-timeSpent-on-Epic-level/qaq-p/2553250

[Oksana Kolesnyk]

Hello @Marc - Devoteam 
Thank you for the answer

1. Before the Jira UI was updated, I had such automation in a few projects, and it worked. https://community.atlassian.com/forums/Automation-questions/Jira-automation-rule-to-sum-up-timeSpent-on-Epic-level/qaq-p/2553250
However, right now I get an error, and it does not work.
The trigger is Work Logged.

2. I am trying to set the same automation but trigger is Scheduled (for example each 5 minutes). I need to calculate Σ Time spent and Σ Original estimate for closed Epics. On a set up screen, second step it shows me "This component may be incompatible"

I have reviewed Forum and tried to copy setting of automations for Σ Time spent and Σ Original estimate. Each time I get some error.