Sum of child issues values to parent issue

Questions & Answers
1

Hi team,

I have a parent issue, and there can be multiple child issues inside it (not subtasks).
There is a field GDP on parent and child issues.
I just want to sum up GDP values of children then calculate the overall percentage and show that on parent ticket.

Can you please help me in this.
Thanks

2

Hi,

The first step for implementation of this use case is to import the Issue links as described herein the documentation:
https://docs.eazybi.com/eazybijira/data-import/advanced-data-import-options/import-issue-links

There can be several options to do that, but this example should be the closest:
https://docs.eazybi.com/eazybijira/data-import/advanced-data-import-options/import-issue-links#Importissuelinks-Bugs

name = "Bugs"
outward_link = "relates to"
issue_type = "Bug"
dimension = true
multiple_values = true

The idea is that the configuration collects the keys of the related issues at the parent level. Then, using those keys, we can calculate the numeric amount of the field from the children.

In the case of the above-mentioned example, the configuration collects bug list for stories:

image
image1424×928 105 KB

Now, I can create a custom formula for counting the measure from the children of each story:

Sum(
[Issue].[Issue].GetMembersByKeys(
[Measures].[Issue Bugs]
)
,
[Measures].[Numeric field created]
)

Note to use the correct names of the measures in this formula.

Kindly,
Janis, eazyBI support