Aldorock apps for Atlassian

Epic Totals for Jira

Story points, estimates and time spent of an epic's children added up, shown on the epic, on a dashboard, and written to a field so boards and JQL can use them.

Getting started

  1. Install Epic Totals for Jira from the Atlassian Marketplace.
  2. Open any epic (or any work item with children). In the toolbar under the summary, click the Epic Totals app button once; the panel then stays on your work items. It shows children, subtasks, story points, original and remaining estimate, time spent, progress, and the split by status and by type.
  3. Add the dashboard gadget Epic Totals to a dashboard and choose a project (open epics) or a JQL query for the parents to list. Sort by any column, export CSV.
  4. Write totals to fields (optional). Under Project settings, Apps, Epic Totals, map each metric to a custom number field. From then on the app writes the epic's totals whenever a child changes, so you can show the values on boards and cards, filter with JQL and build reports.

What is counted

Direct children of the work item (stories, tasks, bugs under an epic) and the subtasks of those children. Grandchildren through other hierarchy levels are not followed. Story points are read from both of Jira's fields, "Story Points" (company-managed projects) and "Story point estimate" (team-managed projects), whichever a work item has. Time values come from Jira's time tracking: original estimate, remaining estimate and time spent, shown in hours and minutes.

The panel counts what you are allowed to see. Field writes are made by the app and count everything in the project.

Progress

When any child has story points: done story points divided by all story points. Otherwise: children in a Done status divided by all children. Subtasks count towards points, not towards the child count.

Writing totals to fields

StepWhere
Create a custom field of type Number for each total you want (for example "Epic rollup points", "Epic progress %", "Epic hours spent")Jira settings, Work items, Custom fields
Add the fields to the screen used by epics in the project, or the write is refused by JiraProject settings, Screens
Map the metrics to the fields and saveProject settings, Apps, Epic Totals
Click "Recompute all epics" once to fill existing epicsSame page

After that, creating, deleting, moving or changing a child (story points, estimate, time logged, status, type) recomputes the parent within seconds. Time metrics are written as decimal hours. Progress is written as 0 to 100. A value that has not changed is not rewritten, so there is no update noise.

Only Jira admins and project admins can change the mapping or run a recompute. The panel's "Write totals now" needs edit permission on the epic.

The dashboard gadget

Project mode lists the project's epics that are not done. JQL mode lists any parents, for example project = MSD AND issuetype = Epic AND labels = q4; add your own ORDER BY if you want one. Up to 100 parents are shown; the gadget says when more exist. Columns are chosen in the gadget's settings; sort by clicking a header; Export CSV downloads the table with hours as decimals.

Limits

Changelog