nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculate sum of custom number field from all subtasks with an Event-based Action

Estelle Decanis

Hi,

I want to use an Event-based Action to sum a number field.

More precisely:

The customfield_10238 is present in all subtasks of a story, and I want to display the sum in a field of the story (customfield_10231).

I found some conversations about this but I can't apply to my situation. Could any of you help me?

Thanks in advance

Accepted answers

David Fischer

Hi @Estelle Decanis ,

it's actually not that easy. You can use an event-based action that listens to changes to the customfield_10238 field on issues of type sub-task. Then you can use a Set Issue Fields post-function on that action to set the parent issue's customfield_10231 to the sum of customfield_10238 on all sub-tasks. You have to select "Parent of the current sub-task" as the Target Issue(s), and for the value a script like:

{{ targetIssue | subtasks("customfield_10238") | sum("fields.customfield_10238") }}

However, this will only work if customfield_10238 is present on all sub-tasks, otherwise it'll return NaN.

Another difficulty is when you add or remove a sub-task. You also need to recalculate the parent issue's customfield_10231 value.

All comments

Mark Segall

Hi @Estelle Decanis

You can accomplish this through automation (Note - This assumes your custom fields are numeric fields):

TRIGGER: Field Value Changed
CONDITION: Issue Type = Sub-Task
BRANCH: Parent
- ACTION: Edit Issue (select your custom field 10231) and use the following:
  - {{issue.subtasks.customfield_10238.sum}}

Estelle Decanis

Thanks for your help @Mark Segall . Indeed I had done the automation.

I want to take the time spent of the ticket, transform it in hour and make a sum in the parent ticket. It's easier to work directly with Event-based Action.

And with automation, the trigger corresponding to the update of the time spent does not work. So I would really prefer to use an event-based action

Mark Segall

Understood - I'll defer to other community members. Good luck

Estelle Decanis

ok thank you

Estelle Decanis

Hi @David Fischer You have answered a question of this type, have you got an idea ?

David Fischer

Hi @Estelle Decanis ,

{{ targetIssue | subtasks("customfield_10238") | sum("fields.customfield_10238") }}

However, this will only work if customfield_10238 is present on all sub-tasks, otherwise it'll return NaN.

Another difficulty is when you add or remove a sub-task. You also need to recalculate the parent issue's customfield_10231 value.

Hannes Obweger - JXL for Jira

Hi @Estelle Decanis

for a completely different direction - is it a hard requirement for you to put your sub-task calculations into a field at the parent issue?

I'm asking because there's a number of apps in the Atlassian Marketplace that would perform such calculations "on the fly", based on a given set or hierarchy of issues. The advantage of such a solution is that it is often far more lightweight and flexible, as you don't need any kind of automation or scripting. The disadvantage is that you can't usually use the result in other Jira views or JQL.

If this is a direction that could work for you, I'd be more than happy to share how this works in the app that my team is working on, JXL for Jira.

Best,

Hannes | https://jxl.app

Estelle Decanis

Great! It works. Thank you very much @David Fischer

Estelle Decanis

@David Fischerone last question.

The customfield_10238 calculation should be triggered when there is a logtime entered. So I put the trigger on the update of the Time spent field.
Unfortunately this does not trigger the action. What is the error?

In the meantime I added Original estimate (and made a voluntary modification) to make it work

Estelle Decanis

Thank you for your feedback @Hannes Obweger - JXL for Jira

On each subtask the collaborators enter time. And I have to display the total time of all these subtasks on the parent ticket. Indeed in a field, in order to show it in the dashboards.

There are certainly points to study on other issues

David Fischer

Because Jira doesn't trigger an event when that field is updated.

Have you tried listening to the Work Log Created event?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

jira-misc-workflow-extensions

event

sum