Jira reporting

Jason Desir

Hi

I'm trying to build a dashboard which users can view the following data

 

• Number of projects due to be completed in a given period.
• Number of tickets completed
• Number of tickets with over X number of estimated days

 

I've already built some data using the apps that are available but none of them quite hit the mark

any help would be greatly appreciated

Jason

 

Mary from Planyway

Hi @Jason Desir 

It's Mary from Planyway for Jira: roadmap, workload, time tracking.

 

Although third-party apps can enhance these capabilities, I'll guide you through achieving this with JIRA's native functionalities first.

1. Number of Projects Due to be Completed in a Given Period

For projects, since JIRA primarily focuses on issues, you might need to creatively use JIRA issues to represent or track your projects' progress and due dates.

• Approach: Use a JQL query to identify issues representing projects due for completion within your specified timeframe. Then, use a gadget like the "Filter Results" gadget to display this information on your dashboard.

  project in (PROJECTKEY) AND issuetype = "Project" AND due >= startOfDay() AND due <= endOfDay("+30d")

   

  This query assumes you have an issue type called "Project" or a similar setup. Adjust the project key and time frame as needed.

2. Number of Tickets Completed

To track the number of tickets completed, you can use the "Filter Results" gadget or the "Pie Chart" gadget to visualize the status of issues.

• Approach: Use a JQL query to filter issues that have been completed within a specific period.

• status = Done AND resolved >= startOfDay("-30d") AND resolved <= endOfDay()

   

  This shows tickets marked as Done in the last 30 days.

3. Number of Tickets with Over X Number of Estimated Days

This requires a bit of creativity since JIRA doesn't directly store the number of estimated days in a simple field for comparison. You'll need to use the "Original Time Estimate" or "Time Tracking" fields.

• Approach: If you're using time estimates, you can try to filter issues based on the original time estimate exceeding a certain threshold (e.g., X hours, since JIRA time estimates are in seconds).

  project = PROJECTKEY AND originalEstimate > "Xh"

   

  Replace PROJECTKEY with your project's key and Xh with the threshold of hours that equates to your X number of days (e.g., "40h" for 5 days, assuming an 8-hour workday).

Implementing on Dashboard

1. Create a New Dashboard: Navigate to Dashboards > Create Dashboard in JIRA. Give it a name and description.
2. Add Gadgets: Click "Add Gadget" on the dashboard screen, then look for and add the "Filter Results" gadget or any other relevant gadgets. Configure each gadget with the JQL queries mentioned above.
3. Save and Share: After configuring your gadgets with the right queries, save your dashboard. You can also share this dashboard with your team or other stakeholders.