Sum of time spent of blocking work items

Return the sum of the time spent of the linked work items linked to the current work item with the link type "is blocked by" in hours.

Configuration

Create a Custom smart number field and use the General parsing mode.

Expression

CODE

%{sum(append(fieldValue({issue.timeSpent},linkedIssues("is blocked by")), [0]))/60}

If the resulting number from the expression contains too many decimal numbers, feel free to select one of the available display formats or to configure it manually.

Format

Default

Used parser functions

The links lead to the JWTC documentation because the parser functions are shared functionalities.