Using JQL to search for who flagged most issues in a project

Emma October 13, 2016

New to JIRA & JQL, how can I search for which user on a project has flagged or raised the most issues using JQL?

2 answers

1 accepted

0 votes
Answer accepted
Tarun Sapra
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 13, 2016

Easiest way to do it is to search for that project in JQL like

project  = "xyz"

and then create a  pie-charts based on reporter and it will become clear which user has created/ flagged the most issues.

Tarun Sapra
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 13, 2016
1 vote
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 13, 2016

Emma,

Tarun's answer is correct assuming you want to be able to regularly see at a glance the distribution based on individuals. You will, if you haven't already, want to create a dashboard and add the desired gadgets. Note if you are looking at an entire project you don't need to create a filter since you can list the project key in the filter/project field of the gadget. Good gadgets for this type of solution are:

  • pie chart (ok if you just want percentage),
  • two-dimensional (great for illustrating more details, e.g. individual vs. status or individual vs. priority, etc.), 
  • issue statistics (similar to pie chart but w/ more detail)

Now, if you aren't really looking for a dashboard solution and simply want to create a list then all you need to do is to filter on the project and add the columns you want, e.g. "Reporter", "Assignee", etc. Of course as the list gets long, and it will quickly, you can't really assess distributions, hence the use of dashboards.

BTW, unsure what you meant by "flagged". Hope this helps.

Suggest an answer

Log in or Sign up to answer