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 · Accepted solution]

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. 

[Bill Sheboy]

Hi @Oksana Kolesnyk 

Just following up to check if this answered your question.  If so, please consider marking this one as "answered".  That will help others with a similar need find solutions faster.  If not, please let the community know what help you need with the rule changes.

I do note an error in the rule you posted where the JQL for the second Lookup Work Items action is incorrect.  Did you notice that?

Kind regards,
Bill

[Oksana Kolesnyk]

Nope. I have not gotten an answer to my question. 
My main question is how to set it up through Trigger - Scheduled. 
 
It works for me with the trigger when a work item is updated, etc. (I've fixed JQL mentioned above).
However, when I try to use the same automation but Trigger "Scheduled", I get an error.
How to set up automation for sum thru Trigger "Scheduled"?
 

[Bill Sheboy]

With the Scheduled trigger, you can optionally add JQL so the rule provides work items to process.  Your rule is missing that JQL and so the errors appear.

Please add JQL to the trigger for the work items for which you want to update their parents.

[Marc - Devoteam]

Hi @Oksana Kolesnyk 

So As @Bill Sheboy mentions, place the JQL:

type in (Story, "Tech Task", Task, Sub-task)

In the scheduled trigger and remove the condition from the rule.

[Oksana Kolesnyk]

Thanks. It works