You can use JavaScript to modify the results for each column. The trickiest part is to iterate through all the linked issues (array) if there is more than one.
First, click on column “links issues” and choose to Add calculated column (see the documentation for details: Data mapping)
eazyBI will create a new column with the data type String that is suitable for mapping as a dimension.
Now you add the JavaScript to the calculated column (see the documentation for details: Data mapping).
The code that returns a separate list of linked issue IDs for the “links issues” column might look like this:
//check if there is at least one link
if (doc.links.issues.length) {
var tissuelist = new Array();
//iterate through individual links one by one
for (var i = 0; i < doc.links.issues.length; i++) {
var links = doc.links.issues[i];
//from each link, get the issued
tissuelist.push(doc.links.issues[i].issueId);
}
return issuelistzb.join(",");
}
The data mapping for the “links issues” column might look like in the picture below.
