Finding Tickets With Commonalities

Taylor purcell

Currently I am tracking bug reports and non-conformities in JIRA. I want to create a report from a filter that shows repetitive issues or trends in order to show a high level "top 5 common issues". I figure my best bet would be to use a dashboard that pulls from a filter i create.

I'm having trouble with the JQL query and am not quite sure how to structure the syntax in order to pull that list of tickets that have commonalities.

How can I put this all together in order to generate that living report?

Bill Sheboy

Hi @Taylor purcell -- Welcome to the Atlassian Community!

Unless you have a fixed list of keywords or plan to regularly update the JQL, I am unclear how you could do this with out-of-the-box features.

• Let's assume you are looking for specific keywords or phrases in the text fields (e.g. summary, description, etc.).  You could use the CONTAINS ~ operator to look for those, and perhaps set another custom field (such as with an automation rule) to make reporting easier.  https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-CONTAINS-CONTAINS--
• You would regularly need to update that query/automation rule as new keywords/phrases occur

Two other ways to help solve this are with money and divide-and-conquer:

• money: investigate marketplace addons to find such patterns in the text fields, and create word cloud type reports
• divide-and-conquer: when bugs are created, have people select from a single-select custom field or add labels, enabling easier grouping and reporting with built-in features.

Kind regards,
Bill