JSD report by individual customer/reporter

[Malin]

How can I create a report that shows how many individual reporters that has created an issue in our service desk Project? For example previous month. 

[Ismael Jimoh · Accepted solution]

Hi Malin,

This is not possible out of the box.

The options are:

• Create a JQL for issues created last month, add a gadget like pie chart  on a dashboard with the section selection based on reporter.
• Pull a report with a plugin (You will need to check if there are any that allows a count function of JQL) or
• Pull the report from the database (EazyBi reporting could help here).

The problem is JIRA has no way of performing a count based on a field. The closest I know of are the above.

[Malin]

I resolved this with creating a report, based on the fields "Reporter" and "Created Date". Then I filtered the report on "Past year by month". Then I exported the report to Google Sheets where I filtered out duplicates. 

At least I know now that it's not possible out of the box. Thanks 

[Ismael Jimoh]

Great. Thanks for sharing @Malin.

The first suggestion I guess is the closest you get to an out of the box solution. You cannot export the gadget though.

Thanks again for sharing.

[Jack Brickey]

While the following isn’t exactly what you asked for you might find it useful.

create a dashboard and use the two-dimensional gadget with y-axis being reporter and x-axis being say issuetype. Use a filter that is for the last 30d or similar.