Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Is there a way to get the Average comment to resolutions report and comment count on actual ticket report.

2 answers

1 accepted

1 vote
Answer accepted

@lapacquah_bryant -

What do you mean by average comment to resolution?  In regards to comment count on actual issues, are you looking at both internal and public comments?

Please clarify if you can, so we can further advise.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

Good morning 

I am referring to the comments on the issue/ticket thats submitted.

I think that the user wants to know the percentage of Comments to those that are Resolved.  

I was told that there is no JQL for percentage and to use a Dashboard gadget.  

Thanks for the follow up.

@lapacquah_bryant -

You are right that JQL doesn't have percentage function out of the box + Dashboard gadget.  In addition, there is no out of the box field that tracks comments count against an issue.

However, here is an idea for you to at minimum to obtain the comments count against issues.  Afterward you can use it in JQL and manually generate your reporting needs.  Here is how -

1) Create a custom field (number data type) and added to your projects issues.

2) Use Automation for Jira to create a rule to be triggered by the action "When issue is commented".  In the rule to increment the new custom field.

This will work for everything going forward.  For all existing issues, you will have to manually populate the field.

Hope this idea helps.  If so, please click on Accept answer when you have a chance.

Best, Joseph

Hello @lapacquah_bryant,

I am Marlene from codefortynine.

Another option would be our apps Dynamic Custom Fields for Jira or Comment Custom Fields for Jira.

With our apps you can calculate the number of comments per issue dynamically and use it in JQL and for your issue statistics. 

Comment Custom Fields has its focus - as the name indicates - on the comment field. Dynamic Custom Fields comes with a greater flexibility since you can create dynamic fields that derive data from other fields besides comments. 

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events