First Comment Author as Dimension

Questions & Answers
1

I have seen a couple of questions related to first comment date and excluding the reporter, but I’d like a way to to identify who the first “Agent” was to comment on an issue in Service Management as that is the action that stops the Time to Response SLA. At the moment we use Assignee, but this result in data that is no accurate if the ticket is later reassigned to another agent.

2

Hi, @seanhickey.1111

Welcom to the eazyBI Community.

If you are looking for the first comment Author. Please consider creating JavaScript calculated custom fields Go to the Jira import options, Custom Field tab and scroll down to the “Calculated Custom fields”.

Create a new calculated custom field, the configuration should look something like this:

Screenshot 2025-02-26 at 11.53.02
Screenshot 2025-02-26 at 11.53.021408×1108 81.9 KB

The JavaScript should look something like this:

let comments = issue.fields.comment.comments;
if (comments.length > 0) {
  var comment = comments[0];
  return comment.author.displayName; // or comment.author.name for username
}

After creating this custom field, please select it for the import. Perform the import.

Use the new dimension in the report.

Kindly,
Ilze