Smart values for jira timesheet

Lara Sousa

Hey guys!

I'm creating an automation in Jira and I need a smart value or html script that returns the sum of a specific user's worklog within a defined time interval.
I saw some smart values like {{worklog.timeSpentSeconds.sum}}, but I need something more specific for my case, in addition to needing this return in hours. It's possible?

Aron Gombas _Midori_

There is an automation action Create variable that allows creating from your own variable by evaluating other variables, using math, etc.

You should try to use this action with an expression that does the aggregation you want.