New Report - No comment for x days

[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 > …