Custom field values in a parent issue

James · July 5, 2018, 12:33pm

Hi there,

I am configuring a report for a client that requires a measure of custom field values in an issue’s parent.

I.e. A subtask has a field called Service, and the parent has a field called Type. I want to show the number of subtasks for each service broken down by the Type value of the parent.

I’m not sure where to even begin with the mdx for this, so any help is greatly appreciated!

Thanks,
James

janis.plume · October 2, 2018, 7:00am

James,

The solution for this use case is to create a calculation iterating over the Issues with the Filter-Descendants functions and correctly filter the subtasks having the parent “Type” equal to the dimension member in the report. One example of such construction is the following:

Nonzero(count(
  Filter(Descendants([Issue.Sub-task].CurrentMember,[Issue.Sub-task].[Sub-task]),
   ([Measures].[Issues created],
    [Type of Issue].DefaultMember)>0 AND
   [Issue].CurrentHierarchyMember.Parent.get('Type of Issue')=
   [Type of Issue].CurrentMember.Name
  )
))

Note that this formula iterates over the “Sub-task” hierarchy and I have the “Type of Issue” at the parent level to filter by.

Kindly,
Janis, eazyBI support