It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Report on Issues Resolved by Agent in Service Desk

I need to create a report that shows the number of issues that have been resolved per agent in service desk.  For example I want to see in one report

Issues Resolved Last 30 days

Agent 1 - 10

Agent 2 - 40

Agent 3 - 4

Can this be done with Service Desk reports, or maybe a filter?

1 answer

Hi Evan,

You can use a query similar to the one below:

project = "Project Name" and assignee = first.last and status = Resolved and createdDate >= 2016-03-21 and createdDate <= now()


This will return all issues that were created within the dates desired and resolved by a particular service desk agent. 

If the assignee changed, then the report result won't be accurate.

Is there a better idea?

Are you trying to get a report of tickets resolved by a specific service desk agent or by a group of them? Are you trying to avoid repeatedly updating the query?

You could leave assignee out of the query, which would return tickets resolved by agents within a certain service desk project. You could then sort by assignee.

Or you could create a user group for service desk agents and use that in place of the assignee in the query. Then you would have to keep the group up to date, but you wouldn't have to rewrite the query. 

I did create a filter on my dashboard to show these stats. It does report off the assignee, i’ll post what I made tomorrow.

@Evan Overby - can you share what you did? I'm looking for this same type of data

 @Evan Overby can you post what you did on your dashboard to show stats based on assignee?

Sorry for the delay. I ended up creating a filter for my project, then using the pie chart gadget to display the information quickly on my dashboard. In this example I am looking anything resolved in the last 4 weeks in one project. Pie Chart will then show you the number of tickets, and how many each user resolved. 

project = MYPROJECT AND status in (Resolved, Closed, Done) AND resolved >= -4w AND assignee in (user1, user2, user3, user4)

Pie Chart Settings:
Filter: <Put your newly created filter name here>
Statistic Type: Assignee

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

344 views 1 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you