Aggregate Numeric fields of Subtasks

Ray Balmeo Cagayon April 6, 2024

I have generated automation to create subtasks and assign test hours per subtasks.

  1. Task 1 - 4 Hours (Under Custom Numeric Field)
  2. Task 2 - 3 Hours (Under Custom Numeric Field)
  3. Task 3 - 6 Hours (Under Custom Numeric Field)
  4. Task n - 4 Hours  (Under Custom Numeric Field)

As the Tasks get completed, I will need to re-assign the values to Zero (0).

What I wanted to do is to calculate the sum of this hours and calculate it against a predetermined date and see if there is a risk of missing it.

 

is there a possibility to calculate the agregate of these numeric fields and add this to the current date and time to see if i still fall below my target date?

I only have one Custom Field (Test Hours) assigned to the subtask.

 

1 answer

1 accepted

2 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 6, 2024

Hi @Ray Balmeo Cagayon -- Welcome to the Atlassian Community!

You mention automation, and so I am assuming you mean automation rules.

You also note both Task and Subtask issue types:

  • for subtasks, you could gather and sum the values with {{issue.subtasks.yourField.sum}}
  • for Tasks, you could use the Lookup Issues action with JQL to gather the issues, and then sum the field with {{lookupIssues.yourField.sum}}

Once the sum is available, that could be added to dates using the various increment functions:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-plus-unit---

Then your rule could use conditions for the tests you describe:

https://support.atlassian.com/cloud-automation/docs/jira-automation-conditions/

Kind regards,
Bill

Ray Balmeo Cagayon April 6, 2024

@Bill Sheboy

Thank you. I will give it a go. 

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events