Breadcrumbs

Sum completed child items' story points

đź“š

This template displays the sum of the selected story point field from the child items of the current work item.

If no child items are found, “None” will be displayed.

For the parameter Story points, select the field that represents story points in your instance.

Configuration

To use the Sum completed child items' story points template, simply select it from the template grid. Filter by KPI to find it faster.

Parameters

To complete the configuration, select values for all parameters.

grafik-20250602-084335.png

Expert mode

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

Expression

General expression:

%{sum(fieldValue({issue.cfnnnnn},issuesFromJQL("statusCategory = Done AND 'parent' = "+%{issue.key})))}

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

Display as

Number

Formatting style

Default (unformatted)

Used parser functions

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

Details

1. What does the expression do?

This expression calculates the total of story points or another numeric field from all completed child work items that belong to the current work item. If there are no such child items, the field will display “None”.

2. Step-by-step breakdown

Let’s break it down:

  • issue.cfnnnnn: This refers to the custom field for story points. “NNNNN” should be replaced with the actual ID of your numeric field.

  • issuesFromJQL("statusCategory = Done AND 'parent' = "+%{issue.key}): This function finds all work items that:

    • Are completed (their status category is “Done”)

    • Have the current work item as their parent

  • fieldValue({issue.cfnnnnn}, ...): For each of the found child work items, this function retrieves the value of the field.

  • sum(...): Adds up all the numeric values from the completed child work items.

3. Examples

Suppose you have a parent work item “ABC-1” with three child work items:

  • “ABC-2” (Done, 5 story points)

  • “ABC-3” (Done, 3 story points)

  • “ABC-4” (In Progress, 8 story points)

The expression will:

  • Find “ABC-2” and “ABC-3” (because they are Done and have “ABC-1” as parent)

  • Retrieve their story points (5 and 3)

  • Sum them: 5 + 3 = 8

So, the result displayed for “ABC-1” would be 8.

4. Real-life use cases

  • Sprint or Epic tracking: Quickly see how many story points have been completed by summing up all finished child work items under a parent (like an Epic or a Feature).

  • Custom dashboards: Display the total completed effort for any parent work item, helping teams and stakeholders understand progress at a glance.