Sum of Tempo billable hours | Decadis App Help Center

Use case

Calculate the total billable hours logged with Tempo in the current issue.

Create a new Remote action in Jira administration > Manage apps > Remote actions.

Name the new remote action Get Tempo billable hours.

Select the POST method.

Select the current instance as the default connection.

Enter the following REST path.

Bash

/rest/tempo-timesheets/4/worklogs/search

Enter the following action body in Advanced text mode.

Bash

"{
  'taskKey': [
    '"+%{issue.key}+"'
  ]
}"

You can optionally use the parameters from ("YYYY-MM-DD") and to ("YYYY-MM-DD") to request only work logs in a specific time frame.

Create a new Calculated Number Field (by JWT) custom field.

Name the calculated field Billable hours.

Providing a description will help you to identify what the custom field does.

Add the following expression.

Bash

toNumber(sum(toNumberList(executeRemoteAction("Get Tempo billable hours", "body[*].billableSeconds"),","))) / 3600

Title	Field type
Number of unresolved blocking issues	Number
Number of times a custom field has been changed	Number
Sum of field value from issues in JQL query	Number
Total remaining estimate in an epic (no sub-tasks)	Number
Total time logged on an epic	Number
Difference between the current date and the earliest due date	Number
Total remaining estimate in an epic (all linked issues)	Number
Number of issues in the same version	Number
Months elapsed	Number
Time left before the issue is due	Number
Sum of Tempo billable hours	Number
Number of times a resolved issue has been rejected	Number
Number of hours in the current priority	Number
Number of open subtasks	Number
Total of all story points in an epic	Number
Number of days an issue was in the Open status against a JWT calendar	Number
Operate with field values from sub-tasks	Number
Elapsed time between creation and resolution	Number
Highest value out of several fields	Text