Extract Jira Comment Authors in an eazyBi Report

Other Questions Jira
1

Can you create a calculated field in eazyBi—without using JavaScript—that returns only the names of users who have commented on individual Jira issues? Below is an example of a different approach I’ve attempted. I would appreciate any suggestions for improvement:

let authorsArray = [];
let issueComments = issue.fields.comment;

if (issueComments && issueComments.comments) {
  let commentEntries = issueComments.comments;
  for (let index = 0; index < commentEntries.length; index++) {
    let currentComment = commentEntries[index];
    if (currentComment.author) {
      authorsArray.push(currentComment.author.displayName + "|active");
    }
  }
  let uniqueAuthors = authorsArray.filter((element, pos, arr) => arr.indexOf(element) === pos);
  issue.fields.custom_comment_summary = uniqueAuthors.join("\n");
}
2

In my experience, working with eazyBI calculated members to extract comment authors has been a bit challenging without JavaScript. I found that using MDX functions to read and concatenate custom properties can serve as an effective alternative. One approach is to ensure that Jira’s comment data is imported in such a way that author fields are properly mapped. From what I have observed, creating a calculated member that navigates through these mappings and applies unique filtering is a viable solution, though it may require some trial and error to perfect.