Sum of parent's customs field with subtask condition

Questions & Answers
1

Hello,

I need some help, I tried to do a sum in EazyBI :

I need to do a sum of parent’s customs fields values, with a condition about a subtask.

Ex : If my parent has a subtaks in statut « To be estimated », So I do the sum of parent Custom field “TOTO” + another parent custom field “TATA”.

I tried with : [Issue].CurrentHierarchyMember.Parent.get … but I’m not an expert and I don’t work :frowning:

Do you have an exemple of this type ? or an idea how can I do that ?

Thanks in advance,

2

Hello Yoann,

You may want to use Issue dimension Sub-task hierarchy, and sum the custom field values from Parent level issues if the parent issue children contain issues in “To be estimated” status.

The calculation could be the following (use correct custom field names for issue properties “Issue TATA” and “Issue TOTO” and check the status name:

Sum(
  Filter(
    Descendants([Issue.Sub-task].CurrentMember, [Issue.Sub-task].[Parent]),
    Count(
      Filter(
        [Issue.Sub-task].CurrentMember.Children,
        ([Measures].[Issues created],
         [Status].[To be estimated])>0
    ))>0
    AND
    [Measures].[Issues created]>0
  ),
  [Measures].[Issue TOTO]+ [Measures].[Issue TATA]
)

Ilze,
support@eazybi.com