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

[Emma]

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

[Tarun Sapra · Accepted solution]

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]

docs here - https://confluence.atlassian.com/jira064/displaying-search-results-as-a-chart-720416681.html

[Jack Brickey]

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.