Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

Custom reports - generate one for closed requests per agent for that month

How can we generate a report that automatically shows the closed requests per agent for that month.

4 answers

Hi @Karishma ,

This was one of the use cases we had in mind when developing Custom Charts for Jira.

You can add a gadget to your existing dashboards and create fully custom reports exactly as you need them.

Here is an example I created showing what this report could look like for you:

Resolved Issues by Assignee.png

You can try the app yourself right now on our interactive app playground: https://www.oldstreetsolutions.com/jira-reporting-playground

I hope that helps with your question.

Kind regards,

Tom - Custom Charts Support Team

9 votes

Hi @Karishma

I don't think there's an out of the box report or mechanism for reporting all closed requests by agent. In JSM there's no such report, and with JQL you cannot do aggregations like count or group by agent.

We do offer a commercial app called Dashboard Hub for Jira where you can create that report. You can use the Agents Workload gadget:

Screenshot 2021-03-16 at 09.48.42.png

Or create your own report using a custom chart with the JQL Search gadget:

Screenshot 2021-03-16 at 09.53.27.png

This gadget allows you to perform a JQL query and display the result as a table or custom chart (bar chart, line chart, tile chart, etc.).

Check a live demo here https://bit.ly/ITSM_dashboard

Hope this helps!

2 votes
Esther Strom Community Leader Mar 04, 2021

Can you clarify? Are you looking for a report on who closed the requests, or which requests have been closed that were assigned to a specific agent? Depending on your setup, it's possible that someone other than the assigned agent closed a ticket, so it would help to know which you're trying to determine.

In either case, I'm not sure there's an easy way to get a single report that shows that info for all users. You could search for something like this:

project = phsd AND resolution is not EMPTY AND resolution changed before endOfMonth() after startOfMonth() 

which would show you all tickets that were resolved during the month. If you keep your tickets assigned even after resolution, you could then create a pie chart (or even just sort your search) by Assignee.

But if your tickets are unassigned when they are resolved, or if they've been resolved by someone other than the assignee, that isn't going to help.

You could create a separate filter for each agent using a similar search:

status changed from Confirmed to Closed by xyz before endOfMonth() after startOfMonth()

and then create a separate dashboard gadget for each agent that shows which tickets were closed; the Filter Results gadget might be a good one for that.

The requests are assigned when they are created, I'm looking for a report per assigned agent for closed requests on a monthly basis.

Do we use UserID for agent names? Is it possible to add a chart showing all closed tickets for all agents in the same report?

1 vote
yuliia_b__SaaSJet_ Marketplace Partner Mar 18, 2021

Hi @Karishma

You can try to create a Pie Chart Gadget showing all closed tickets for all agents in Dynamic Filter add-on (developed by my team). It allows you to filter issues by visual composer without JQL.

1. Choose resolved issues for assignee per month as in the example below: 

1.png

(to add more assignees select operator “in”)

2. Add the required data to create a Pie Chart Gadget on Jira Dashboard:2.png

 

Hope it meets your request.

Regards

Thank you for the different options for generating reports. Is it possible to showcase a report centrally in the agent dashboard for 2-3 projects and generate a report showing closed cases per agent for that month for those 2-3 projects combined?

yuliia_b__SaaSJet_ Marketplace Partner Apr 02, 2021

Hi @Karishma 

Yes, it's possible to showcase such a report. Feel free to ask if you need further information.

11.png

Please provide details how and if using a 3rd party app.

It's the third-party app I’ve mentioned before in the first message (Dynamic Filters: JQL Replacer & Gadgets).
Here is a step-by-step example.
1. Select options in the Smart Field Manager. You can choose time, assignee, statuses according to your needs and workflow process. 

2021-04-03_14-05-32.png

2. Add the created Smart Field to the Dynamic Filter and save it: 2021-04-03_1-11-09.png

3. Go to the Dashboard and choose saved Dynamic Filter to configure: 2021-04-03_1-20-24.png
 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

JSM Jira Automation: How to Send SLA Breached Notifications

Hi Everyone, In   this tutorial,  we will show you how you can monitor an SLA, and send notifications before or after the SLA has been breached.   SLA Threshold Trigger The SLA t...

611 views 5 12
Read article

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