Is there a way to calculate the average number of comments based on the status of issues?

[Churui Chen]

I have several status of issues under one project. I am wondering if there is a way to set up a report on the average number of comments per ticket under one specific status. This will help me better investigate why some issues stay unsolved for a long time.

[Matt Doar]

In Jira Data Center one can use a plugin such as ScriptRunner to create a scripted field that shows the number of comments, and sort by that to find issues with a large number of comments. Or if you have access to the database you can use a query such as

select issueid, count(*) from jiraaction group by issueid order by count(issueid) desc limit 5;

[Matt Doar]

For Jira Cloud I'm not sure

[Churui Chen]

Thanks for the answers. But is it possible to have the number of comment count as a column in the issue list, and calculate the average number comment each issue has under each status?

[Hannes Obweger - JXL for Jira]

Hi @Churui Chen

if you're open to solutions from the Atlassian Marketplace, I believe this would be easy to do in the app that my team is working on, JXL for Jira:

JXL is a full-fledged spreadsheet/table view that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called “smart columns” that aren’t natively available - including the number of comments - as well as the ability to group your issues and calculate sum-ups. With these features, you can easily create a view like this:

You can also group by any other field, create nested groups, or configure different sum-up styles.

Since you've tagged your question for Jira Server: While Atlassian doesn't allow new apps to be listed for Jira Server in the Marketplace, JXL is still perfectly compatible; it's just that we need to generate a license for you. If the above looks interesting, just let me know and I'll happily start a free trial for you.

Hope this helps,

Best,

Hannes