Ticket analysis / monitoring tool? Edited

Hello dear community,

 

I´m new here and have been working with jira for a few weeks now.

At the moment i´m working on a project to gather as much information about tickets as possible. All factors like the amount of comments per ticket or how many people were involved while working on the ticket or how long it took to solve the problem have to be found out.

 

Is there any way to do that quickly? I found out about two tools called "new relic" and "datameer". But these cost and I was actually looking for a free way around ;-)

 

Can jql possibly help here?

 

Thank you for any help :-)

4 answers

Any ideas? ;-)

 

I found out some jql commands like:

"Time to resolution" = paused()

"Time to first response" < elapsed("10m")

 

but these don´t really help and are not really what i´m looking for.

 

Looking forward for some useful tips from you guys ;-)

Hi Yousaf,

I am puzzled and unclear from the description on what is that you are really trying to accomplish. 

If you want to track all activity inside a ticket - then you have it as out of thebox functionality existing in JIRA - you can see there how many comments were made, who commented, how is watching the issue

If you want to generate some reporting based on your team activity - i.e. check the ticket "popularity" you can use some advanced JQL's to query that.

To find out tickets where there is more than 50 watchers (or votes) you can use this query:

project = "ABC" AND votes >= 50 AND issuetype = Suggestion

you can then start narrowing down by adding other objects like issue type etc. to get more narrow results

to find out tickets which does not have empty comments

project = "Atlassian Cloud" AND Comments is not EMPTY

or to find out more than x number of comments in the project (or in the task or done by user) start from this JQL

project = "Atlassian Cloud" AND Comments <= 2

 

here is more to read about JIRA JQL https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-764478330.html

 

you can also search for the specific add on's on the marketplace which provide more advances JQL's functions not available inside of standard JIRA

Hi Support,

 

first off: thanks for the help, I really appriciate it ;-)

 

Well this is basically what I want to achive:

- track the average time of how long a ticket/issue took to be resolved

- how many people were involved while fixing the issue (not customers, only support workers in the company)

- how many comments were written throughout the entire issue/ticket

 

I want to make an archive of all the tickets / issues over a longer period of time, e.g 3 years +/- 1, 2 years...

Just an example of how this should look like:

- I have 10 Projects running at the moment and all together have 100 issues, this means 10 issues per project in average

- 200 comments were written in 100 issues, means 2 comments per issue

- for 100 issues/tickets it took 100 hours time to resolve them, means 1 h per issue

 

And then all of this information should be gathered and analysed.

 

There, a lot to read but maybe and hopefully I could give a good example of what i´m looking for.

 

Thank you ;-)

Hi all,

it seems to be pretty difficult to find out the stuff i´m looking for :/ 

 

I installed the JIRA Toolkit plugin but for whatever reason the comment count field does not appear in the search results. I looked for any boxes to check or activate but didn´t find anything.

 

 

I tried this search:

project = "myProject" AND created >= 2015-06-01 AND created < 2017-05-01 ORDER BY "Comments count"

An error occurs that says "Field Comments count" is not possible, so I tried it with comment, comments and count.. but nothing worked.

 

Hoping for some helpful tips from you guys, thanks ;-)

Have you added the field?  The add-on just creates a field type, not a field.  After creating the field, you also need to re-index before it will become useful.

Hi Nic,

 

that´s exactly my problem..

I don´t know how to add/create the new field and how to re-index it.

 

Would be great if you could explain it to me

Hi Nic,

 

that´s exactly my problem..

I don´t know how to add/create the new field and how to re-index it.

 

Would be great if you could explain it to me

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,317 views 14 20
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot