Breadcrumbs

Average field values in sub-tasks

📚

This template calculates the average of the values of a selected field in all sub-tasks of the current work item. Work items with an empty field are excluded from the calculation.

Configuration

To use the Average field values in sub-tasks template, simply select it from the template grid. Filter by Sub-tasks to find it faster.

Parameters

To complete the configuration, select a field for the required parameter.

Expert mode

If you switch to Expert mode you can see the Smart field in the Expression Parser. You can now tweak the expression to create a custom smart field based on this template.

Expression

General expression:

%{avg(filterByValue(fieldValue({issue.cfNNNNN}, subtasks()), !=, null))}

NNNNN is the ID of the custom field you chose for the “Field” parameter.

Display as

Number

Formatting style

###,###.##

Used parser functions

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