How to find reporter who filed maximum incidents from JIRA directly

[Rohit Suryawanshi]

Hi,

How to find reporter who filed maximum incidents from JIRA directly. I would like to get the reporter name for some duration lets say "last 3 months" & had filed maximum incidents.

This I need directly from JIRA, exporting list view in excel & checking is different case.

Let me know if we can do it by some JQL query?

Thanks, Rohit

[John Funk · Accepted solution]

Hi Rohit,

For those types of needs, I usually create a simply filter first. In this case maybe something like: project = ABC AND created <= endOfMonth() AND created > endOfMonth(-3M) ORDER BY created ASC

(there are several ways to calculate "last 3 months). 

Then I create a dashboard or use an existing dashboard and place a new gadget on the dashboard. I use the Issue Statistics gadget.

Then I would use Reporter as the Statistic Type. This is give you a list or reporters with a count for each reporter. 

I hope that helps!

[Rohit Suryawanshi]

Hi John, this works for me. Thanks for your quick help..

[John Funk]

Great! Can you click on the Accept Answer button so the discussion will get closed out? 

Thanks!