Need Jira reports

[balan]

Hi,

I am unable to collect below report from Jira. Someone please help on this ASAP.

1. Report that shows the usage of all the Projects in last 6 months
2. And/Or Report that shows the number of issues created/resolved by each project in the last 6 months.
3. And Report that shows the Project and their respective Project Owners

[balan]

We are using Jira software and Jira service management

[Heenaben Sardarbhai Chaudhary]

Hi @balan ,

1. Build a JQL query
   
   • project = "YOUR_PROJECT" AND created >= -6M
2. and save it. It should capture all your created tickets from project
3. Go to your dashboard and choose the created vs. resolved gadget.  
   1. Choose your filter
   2. period: Monthly
   3. Days Previously: the number of days 180 is 6 months
   4. Trend: No
   5. Display Versions: only major versions
   6. Collection is count
4. This setup will provide a clear view of issue activity over the last 6 months

[Andreas Springer {Actonic}]

Hi @balan

depending on what you mean by "usage of all the projects" in your first point, you might be in need of specialized reporting as this can mean a lot of things.

If the standard Jira reporting options can't give you what you need, I recommend to have a look at Report Builder. It has a number of ready-to-use reports especially for ITSM purposes. Also, its "Universal Report" allows you to put together data very flexibly. Lastly, any kind of report/layout is possible using scripts. If you'd like me to show you how it works, feel free to reach out at any time.

Disclaimer: I work for the marketplace vendor who is offering this app, so obviously I'm biased. 😉

[Patricia Modispacher _appanvil_]

Not working for Report Builder, but can agree! Love that tool.

[Danut M _StonikByte_]

Hi @balan,

This topic is a duplicate of: https://community.atlassian.com/t5/Jira-Service-Management/Need-Jira-reports/td-p/2735665

See my answer:

#1 Create a filter in Jira that returns the issue created or updated in last 6 months:

created >= startofday(-6M) or updated >= startofday(-6M)

Then configure the Issue Statistics gadget of Jira to use this filter and display statistic type by Project. As a result, you will get the list of projects used in last 6 months.    

Also, you could also use the Pivot Table & Pivot Chart gadget offered by our Great Gadgets plugin to display a report like this.

See also https://community.atlassian.com/t5/App-Central/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369 

#2 Create a filter that returns the issues created in last 6 months

created >= startofday(-6M) 

Use the same gadgets to display the stat of created issues for each project.

Create a filter that returns the issues resolved in last 6 months

resolved >= startofday(-6M) 

Use the same gadgets to display the stat of resolved issues for each project.

#3 What do you mean by Project Owners? Do you refer to the Project Lead (that you can set in project settings)?

Danut.