I received this response from EazyBI that solved the problem and thought I’d post here…
Hi Adam,
Thank you for the request and the details provided.
The recommended solution for this use case is to implement a new Javascript calculated custom field in eazyBI. The idea is that with such a custom field we can create a new dimension in eazyBI inheriting down the DeliveryWorkType field from epics to the stories.
For that, you need to add the lines like this to the advanced settings of eazyBI:
[jira.customfield_cf_inherited] name = “DeliveryWorkType Inherited” data_type = “string” dimension = true javascript_code=’’’ if (issue.fields.customfield_NNNNN && issue.fields.customfield_NNNNN.value) { issue.fields.customfield_cf_inherited=issue.fields.customfield_NNNNN.value } ‘’’ update_from_issue_key = “epic_key”
You need to adjust the code and use the custom field ID instead of NNNNN. This example assumes the field is the single select dropdown list.
Once you save the advanced settings, you should see the new field in the custom field list of the data import options:
After the data import, a new dimension will be created and user stories will have the custom field value inherited down form epics. The following report should resolve your case:
Let me know if that works, or you need any further guidance on the implementation.
Kindly,
–
Janis Plume
eazyBI support