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

Accepted Answer
0 votes
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

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
Community showcase
Posted Sep 25, 2018 in Jira

Atlassian Research Workshop opportunity on Sep. 28th in Austin, TX

We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...

433 views 7 5
Join discussion

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