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

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
Accepted answer
Tarun Sapra Community Champion Oct 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.

1 vote
Jack Brickey Community Champion Oct 13, 2016


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
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,306 views 5 11
Read article

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