Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

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?

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?

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

ThinkTilt is joining the Atlassian Family!

This morning, Atlassian announced the acquisition of ThinkTilt , the maker of ProForma, a no-code/low code form builder with 700+ customers worldwide. ThinkTilt helps IT empower any team in their or...

282 views 16 17
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