Calculate sum of custom field in linked tickets across projects

Kenyon Barnette May 21, 2021

As operations and development teams we want to see the sum of a custom field for all linked tickets.

Scenario: Custom field Ticket Value on JSM Project has a value of 10 on issue JSM-1 and a value of 13 on issue JSM-2. 

A development ticket is created on DEV project; JSM-1 and JSM-2 are linked to DEV-1.

Total Ticket Value should on DEV-1 will have the sum of Ticket Value on JSM-1 and JSM-2: 23.

Total Ticket Value is a calculated field using JSU's Jira Suite Utility Calculated Field feature with the following formula: 

sum(linkedIssues('Blocks',"Ticket Value"))++sum(linkedIssues('Relates',"Ticket Value"))+sum(linkedIssues('Duplicate',"Ticket Value"))

IRL the value is not being populated on DEV-1. I would an automation with {{lookupissues}} but custom fields are not available properties of the results. Ideas and suggestions would be greatly appreciated. 

1 answer

0 votes
Kenyon Barnette May 21, 2021

TMW you finally get done creating a detailed community post only to be suggested a related post with nearly an identical subject...

https://community.atlassian.com/t5/Jira-Software-questions/Calculate-the-Sum-of-custom-field-across-projects/qaq-p/1508087

Going to see if the above works. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events