Query for Identifying Team Member has logged less then X number of defects

Question

Hi I need help in this.

Question :- Have multiple project in my organizations, I want to create a query where Jira brings me data of all Testers those have reporter less then 10 defects in specific duration like 3months or 6months.

After this I will use this query to create a dashboard in Jira, that will provide me numbers.

But before Dashboard need to have a query.

Luka Hummel - codefortynine · Answer

Hi @Abhishek Sharma

I think our Quick Filters for Jira Dashboards marketplace app can help you in achieving your goal.

You can use our Quick Controller gadget to filter your wanted time periods with endOfDay(-3M) and endOfDay(-6M). This way, you have two buttons you can use to quickly change the time period of the data displayed.

In the Quick Issue Statistics gadget, you can filter the results with issuetype = bug and select for Field Reporter and for Values shown Issue Count. This way, you can see all users sorted by their count of reported bugs.

Trudy P Claspill · Answer

Hello @Abhishek Sharma

What you want cannot be done with the native query/filter functionality.

The native functionality is designed to get you information about issues, not about people.

You might be able to find a third party app that would enable you to create this type of report. You can find apps on the Atlassian Marketplace.

You could right a query to retrieve all Bugs logged during a certain time period, and include in the output the Reporter (Tester) for each Bug. You could export that information to a CSV file and open it in Excel to do additional analysis on the data.

Or you could use that filter to build a Pie Chart on a Jira Dashboard, using Reporter as the grouping method. That would give you a quick visual of how many Bugs each person reported.

Note that if a Tester has not reported any Bugs in that time period then their name would not be included in the list. You would have to review the Testers in the list and compare that to a complete list of your Testers to find ones that had not logged any bugs in that time period.