Group issues by parent custom field value

Yes, you are correct. eazyBI by default allows analyzing data if the issues themselves have specific field values. We support extending this and inheriting values from a specific level of the hierarchy during import as well. However, the solution will set the parent’s values on children no matter if a child has a value in the field or not.

You can consider using some scripted fields in Jira with more extended and complicated rules to inherit values from parent issues.

In eazyBI you can use some MDX formulas. The simplest option would be asking for parent field value if the issue does not have one on the report with a list of issues in within a specific hierarchy:
CoalesceEmpty(
[Issue.].CurrentMember.get(‘Work Category’),
[Issue.].CurrentMember.Parent.Get(‘Work Category’)
)

You would like to set your hierarchy name instead of in the formula and check the spelling (case sensitive) for Work Category.

The formula above will have limited use and it will work for a report with this Issue hierarchy used in the report and will pick the parent issue in this hierarchy if the field does not have the value.

Daina / support@eazybi.com