You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I am looking for a way to create a report in Jira Service Management, which shows all created vs. resolved tickets per customer organization we have. Ideally, this should also be made exportable as CSV file, with all fields and columns shown.
So for example:
Customer Organization A | Created tickets: 4 | Resolved tickets: 2
Customer Organization B | Created tickets: 2 | Resolved tickets: 1
Is there any way to do that? Or do you know any helpful apps from the Atlassian Marketplace which could help me with this?
Thank you in advance!
Best regards, Petra
Hi @Petra Hasler,
A more convenient option would be to use our Great Gadgets app.
This app offers many gadgets for building powerful dashboard in Jira Service Management. Take a look over this blog article to make a better idea:
More specifically, for addressing your need, you could use the Advanced Issue Filter Formula gadget, which allows applying from simple (COUNT, SUM, AVERAGE) to complex math formulas against the numerical fields of the issues from up to 6 filters.
With this gadget you can have something like this:
I hope this helps. If you have any questions, please contact us at email@example.com.
Hope you are doing fine.
I would recommend checking Atlassian Analytics, which is a powerful Analytics tool that gives you the ability to create reports based on all data stored in Atlassian Datalake.
Atlassian Analytics offers different sets of charts, tables and is a powerful tool for you to create analytics reports. You can even perform SQL queries to get better results! This will also allow you to export data in CSV.
As an alternative solution, you can create reports using the default "Reports" functionality from JSM, but a bit of customization will be needed by using JQL. You will have to list each organization in a JQL by using "reporter in organizationMembers()" statement, by adding the organization name as a parameter on the function.
Hope this helps!
Thank you @Danut M [StonikByte] and @eugenio_onofre for your answers, I really appreciate your help and your insightful responses!
I think both could potentially be useful, however for my specific case I found another way of how to do it by simply filtering and exporting the results.
Thanks again and all the best,