How to create a report that shows an internal comment on a certain transition

[zane.baranovska]

Hi @Sdemidow,

Issue history status transition and commenting are separate changes.
The status transitions are already imported into eazyBI (Import issue change history), but not the comments. You can also import the Internal comments in eazyBI, along with the date when and who commented on the issue.

Here are community posts on how to import comment count on issues by users and dates:

Calculating the number of comments - by specific USER

Hi @chrischarles2002, In the mentioned community post Calculating the number of comments , is an example of how to import comment count using JavaScript calculated custom fields. To count comments by each author, you may modify JavaScript code. To do this, declare that each issue might have a set (array) of user names who have commented on it and comment count accordingly. To represent names of comment authors in eazyBI, you may use some existing dimension which contains user names, like, Assi…

Information, whether the comment is internal or external, is not available on the issue by default, so you can update the code and add an additional check if it is internal. For this, use the getDocument function to call REST API and find the comment details; here is an example:
Last Internal comment - #2 by zane.baranovska.

When the comment count by a user is imported, you can add thsi measure to the report to see how many of the currently answered issues have internal comments and specific status transitions on the same day.

Best,
Zane / support@eazyBI.com