Jira reporting

Jason Desir
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 27, 2024

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

 

2 answers

1 accepted

0 votes
Answer accepted
Maria
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
February 27, 2024

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.
Jason Desir
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 29, 2024

Thank you very much Mary from Planyway for Jira: roadmap, workload, time tracking., most appreciated

Like Maria likes this
0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 27, 2024

Hello @Jason Desir 

Welcome to the Atlassian community.

Tell us more details about what you have tried and how it has not met your needs.

Are you open to using third party apps to meet your requirement?

One point of clarification: The Jira term "Project" is an entity that is a container for "issues" (or "tickets"). A Project doesn't have a completion date. Only issues/tickets have dates, under native Jira functionality. Can you clarify what you are trying to get at with that first bullet item?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events