Issue link field dimension for parent assignee

I am creating a report where I need to be able to add the parent issue assignee (Story) as a Page dimension so that report users can easily filter by Assignee, but also need to display all of the sub-tasks (Issue dimension in Row). For this I would like to create an Issue Link Field Dimension for parent assignee. Here are the advanced setting I am using.

[[jira.issue_link_field_dimensions]]
name = “Parent Assignee”
source_dimension = “Assignee”
issue_key_column = “subtask_parent_key”
group = “Linked issue dimensions”

After adding the dimension to my source data and re-importing the new linked issue dimension is available, but when I add it to a report I get an error, see screen shot. 38%20AM

Hi @cbm360

When checking old community posts I noticed that you haven’t received any answer yet.
The assignee field is not supported for “linked field dimensions”, therefore this approach won’t work to import Parent assignee field as a dimension in eazyBI.
See supported fields for Linked field dimensions here: Issue link field dimensions.
For, the example you can import “Parent status”

[[jira.issue_link_field_dimensions]]
name = "Parent Status"
source_dimension = "Status"
issue_id_column = "subtask_parent_id"
group = "Linked issue dimensions"

In your case, you would need to use a Javascript in advanced settings to define a new pre-calculated field

[jira.customfield_parassig]
name = "Parent assignee"
data_type = "string"
dimension = true
update_from_issue_key = "subtask_parent_key"
javascript_code = '''
if(issue.fields.assignee && issue.fields.assignee.displayName) {
issue.fields.customfield_parassig= issue.fields.assignee.displayName;
}
'''

See another example here:
https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/javascript-calculated-custom-fields#JavaScriptcalculatedcustomfields-Inheritedfielddimension

Martins / eazyBI support