Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Need Jira reports

balan June 24, 2024

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

 

4 comments

balan June 24, 2024

We are using Jira software and Jira service management

Heenaben Sardarbhai Chaudhary June 24, 2024

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 Screenshot (1288).png
Andreas Springer {Actonic}
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 25, 2024

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_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
June 25, 2024

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

Danut M _StonikByte_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
June 26, 2024

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.    

image.png

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

image.png

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. 

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events