New Report - No comment for x days

[Renato_Gomes]

How can i create a report that return the result based on JQL below:

issueFunction in lastComment(“before -3d”) AND project in (“XYZ”) AND status not in (“ABC”) AND issuetype not in (“ABC”) ORDER BY key, status

Result view = gauge

Exemple:

[zane.baranovska]

Hi @Renato_Gomes,

By default, data on the issue comments are not imported in eazyBI. However, you can retrieve such information with a JavaScript calculated custom field (JavaScript calculated custom fields - eazyBI for Jira).

1. First, you might want to import the last comment date as property and measure. The code for JavaScript calculated custom field might look like this:

   #comment last date
   [jira.customfield_lastcommentdate]
   name = "Last comment date"
   data_type = "date"
   javascript_code = '''
   if (issue.fields.comment && issue.fields.comment.comments && issue.fields.comment.comments.length > 0)  {
     var lastcomment = issue.fields.comment.comments[issue.fields.comment.comments.length-1];
     issue.fields.customfield_lastcommentdate = lastcomment.created;
   }
   '''
   

   In import options, select to import last comment date as property and as a measure. eazyBI will create a new measure “Issues with last comment date” to show how many issues have the last comment on each date (Custom Fields - eazyBI for Jira).

2. In the report, define a new calculated measure (in Measures) to get issues that have the last comment more than 3 days ago.

   --all commented issues
   ([Measures].[Issues with last comment date],
   [Time].CurrentHierarchy.DefaultMember) -
   --subtract count of issues that are commented in the last 3 days
   Aggregate(
     [Time].[Day].DateMembersBetween('3 days ago', 'today'),
     [Measures].[Issues with last comment date]
   )
   

   More details on calculated measures and tuples are here: Calculated measures - eazyBI for Jira.

3. Set “Status” and “Project” dimensions on pages to filter data.

Best,
Zane / support@eazyBI.com

[zane.baranovska]

Here are few more topics with JavaScript calculated custom field examples on analysing Jira issue comments:

Exclude reporter on First comment date

Hi, I was working on a script to get the response time from ticket creation to time of first response from the assignee. I found this https://community.eazybi.com/t/creating-a-time-to-first-comment-date/2469 and it really help. But I found that it also triggers even if the response is from the reporter. How can I exclude the reporter response so I can get the correct response time or is there any other way to do this? Thanks, Allen

Calculating the number of comments - by specific USER

There is a similar post referencing adding JavaScript to EazyBI’s advanced settings to get the actual COMMENT data out of JIRA: https://community.eazybi.com/t/calculating-the-number-of-comments/255 This solution works great. However would like to know if a similar solution would work to get the comments made by a specific Assignee and / or Reporter. I have Rows with a list of all existing projects, and would like to have a column with a user-defined, [Measure] > “Calculated member” that is a…

Calculating the number of comments

Hi, I have a table for Issues Created by Reporters. I’m trying to make a new field that calculates the sum of the number of comments on all of those issues. This is the script I’m using: Sum( [Reporter].CurrentMember, [Measures].[Comments total] ) I’m getting null cells with this formula, what’s wrong with it? Thanks, Yaniv

Graph by comment count

Hi everyone. I’d like to draw a graph based on the number of comments on each issue. (The comment count function is already configured by javascript.) Rows is Number of comments (Duplicate Except) Columns is Number of issues For example, 39 Comment issues one. 31 Comment issues one. 29 Comment issues one. 26 Comment issues one. 25 Comment issues one. 20 comment issues are two. That is, I want the picture below How can i make Rows and Columns? [graph]

Creating a Time to First Comment date

Hi, I’m trying to create a “Time to first Response” measure that show the time from issue creation to the time of the first comment. In order to do this, I am attempting to leverage the difference between the issue created date and a custom field I am importing. The custom field is generated in Advanced Settings with: [jira.customfield_firstcommentdate] name = "First comment date" data_type = "datetime" javascript_code = ''' var comments = issue.fields.comment.comments; if (comments.length > …

[Marcelo_Ignacio_Cid1]

Hi @zane.baranovska ,
In the case of wanting to obtain the first comment (the text, not the date), how should I modify the code?

[zane.baranovska]

@Marcelo_Ignacio_Cid1 to check on the first comment value, you might make three changes:

• The first comment is the item [0] in the comment array. u
• Look for the comment field “body”
• Set data_type to the text

The advanced settings and JavaScript to get the first comment text might look like this:

[jira.customfield_firstcommenttxt]
name = "First comment text"
data_type = "text"
javascript_code = '''
//check if there are any comments
if (issue.fields.comment && issue.fields.comment.comments 
    && issue.fields.comment.comments.length > 0) {
  //look for the firt item in the array
  var firtcomment = issue.fields.comment.comments[0]
  //get the field body content
  issue.fields.customfield_firstcommenttxt = firtcomment.body;
}
'''

[Marcelo_Ignacio_Cid1]

Thanks @zane.baranovska,
It´s amazing