Skip to main content

Rollup

A Rollup field totals a work item's children in one number, such as the story points of an epic or its % done.

You can count, sum or average the children, or take the smallest or largest value. The value stays current as the children change.

FieldCraft reads the children with the app's access. A Jira admin must acknowledge app access first.

The % done field on an epic, shown as a progress bar at 30 %

What you see​

On the work item, you see the number with its unit, such as 62%, 12.5 h, 30 min or 2 d.

A % done value also shows a progress bar that turns green at 100.

Lists show the same text. Search, sorting and exports use the stored number.

If the work item has no children of the kind you chose, you see None.

Settings​

SettingWhat it doesDefault
CalculateSum, Count of work items, Average, Minimum, Maximum, % done, by number of work items or % done, by the source fieldCount of work items
Source fieldsUp to 3 fields, in order. For each child, the first one with a value countsNone, so you pick one
Store the value inHours, Minutes or Days. Shown only when every source is a time tracking fieldHours
Children to includeDirect children, Sub-tasks only or Child work items, without sub-tasksDirect children
Only children in these statuses (optional)Only children in these statuses count, for example Any Done statusEvery status
Work types (optional)Only these work types or All except these work types, matched by nameEvery work type
Counts as doneFor the two % done choices, the statuses that count as doneAny Done status
DisplayA plain number, a traffic light or a progress barPlain number

In Source fields, you can pick number fields, the points of T-Shirt Size fields, and Original estimate, Remaining estimate and Time spent.

To cover company-managed and team-managed spaces, choose both Story Points and Story point estimate.

Empty or zero​

With no children of the kind you chose, the field is empty.

With children but none that match, Sum and Count of work items show 0. Average, Minimum and Maximum stay empty.

Values have up to 2 decimals. FieldCraft rounds a % done value down, so it shows 100 only when every child is done.

Example: story points on the epic​

You want each epic to show the total story points of its children.

  1. Create the field from the Story points on the epic recipe, or open the configuration page of a Rollup field.

  2. In Calculate, select Sum.

  3. In Source fields, select Story Points and Story point estimate.

  4. Select I understand, and the values may be shown to everyone who can see the work item, and select Save.

Result: An epic with stories of 3, 5 and 8 points shows 16. When a story changes, the epic follows shortly after.

Search with JQL​

JQL compares the stored number.

To find epics with more than 20 points, use:

"Story points on the epic" > 20

To find open work that is less than half done, use:

"% done" < 50 AND statusCategory != Done

When the value updates​

FieldCraft recalculates the parent when a child is added, removed or moved. It also does so when a child's source field, status or work type changes.

It waits until the children are quiet for about 20 seconds, and at most 5 minutes.

For this, you need Update parents and children turned on in the Settings tab. See FieldCraft settings.

When you open the parent, FieldCraft reads the children again, at most every 15 minutes.

To fill in older work items, recalculate existing work items.

Things to know​

  • A Rollup reads one level of children. It can't use another Rollup field as a source.

  • If you store Days, a day is 8 hours, unless an AI assistant set another day length. The work calendar isn't used.

  • A Rollup of counting fields, such as Time in Status, moves only when a child changes or you open the parent.

  • A Rollup reads up to 10,000 children. With more, it keeps its last value and reports an error.