Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Create a eazybi report showing last comment by assignee

I want to create a Eazy BI report showing last comment by assignee as an dimension. If this is possible please let me know how to do this.

1 answer

eazyBI does not import comments by default. However, you can access them during import and use javascript to describe what you would like to import.

Here I added two definitions for Assignee last comment (could be imported as property) and Assignee comment date (could be imported as measure and property). Both fields are using a common javascript code via field Assignee comment date:

 

[jira.customfield_comment_a]
name = "Assignee last comment"
data_type = "text"

[jira.customfield_comment_date_a]
name = "Assignee comment date"
data_type = "datetime"
measure = true
javascript_code = '''
var commenta = new Array();
var allcomments = issue.fields.comment;
if (issue.fields.assignee) {
 var assignee = issue.fields.assignee.key; // get assignee key
 if (allcomments && allcomments.comments ) {
   var comments = issue.fields.comment.comments;
   for (var i = 0; i < comments.length; i++) {
    var comment = comments[i];
    if( comment.author.key == assignee ){ // validae if comment auuthor is the current assignee
     issue.fields.customfield_comment_date_a = comment.created; // fill in comment date
     issue.fields.customfield_comment_a = comment.body // fills in assignee last comment as well
    }
   }
 }
}
'''

1. Add the custom fields definitions to eazyBI advanced settings or ask Jira administrator or eazyBI administrator to do this for you. eazyBI advanced settings are common for all accounts, and only Jira/eazyBI administrators have access to the settings.
2. Open source data Jira import options for edit after changes in advanced settings and select the custom fields Assignee last comment and Assignee comment date for import and run an import.
You can import Assignee last comment as a property and Assignee comment date as a measure and property. Use measure Issues with Assignee comment date to filter issues with assignee comment over time.

Here is a report example with this:
a76751ffe6bc4e0df271127fd63718d5.png

Here are more examples on how to import comments into eazyBI:
https://community.eazybi.com/t/calculating-the-number-of-comments-by-specific-user/1788/2
https://community.eazybi.com/t/new-report-no-comment-for-x-days/6671
https://community.eazybi.com/t/pull-in-all-comments-for-an-issue/6137
 

Daina / support@eazybi.com

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you