Report: created vs. resolved tickets per customer organization

[Petra Hasler]

Hello everyone, 

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

[Danut M [StonikByte] · Accepted solution]

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:

An effective dashboard for Service Desk and Customer Support teams in Jira Service Management 

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 support@stonikbyte.com.

Thank you,

Danut Manda

[eugenio_onofre · Accepted solution]

Hi @Petra Hasler

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!

[Petra Hasler]

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, 
Petra