Dashboard for Reporting Previous Sprints

[Sian Snook]

Currently to highlight the team development I look at the output from the Sprint Reports.

I take the number of items 'Done' compared to 'Not done' i.e 8 done 2 not done = 80% delivered. As you can imagine this is a lot over manual work.  is there a filter and gadget that could do that title of data. 

Committed work = items of JIRA issue taken into the Sprint

Completed work = items of JIRA issue done within the Sprint

Any ideas are welcomed :) 

[Sian Snook · Accepted solution]

I want to compare the burndown and sprint health currently can only see the current Sprints.. How i do that?

[Alexey Pavlenko _App Developer_]

Hi @Sian Snook ,

It's, unfortunately, impossible to achieve what you want in JIRA native. JQL filters can partially solve your problem, but only if you set up individiual JQL filters for each sprint.  To consistently define the delivered state, you would need to set the resolution date to match the end/complete date of a sprint.

You can use the app I have developed which covers almost everything you need - Multi-team Scrum Metrics & Retrospective.

Best regards,
Alexey

[Vitalii_Bobak_SaaSJet]

Hi @Sian Snook

It sounds like you're doing a great job tracking your team's development using the Sprint Reports. I suggest you to try Sprint Performance Report (which available throw Time in status add-on). The report automatically provides insights into key sprint metrics, including:

• Committed work: The number of Jira issues taken into the sprint.
• Completed work: The number of Jira issues marked as "Done" during the sprint.

It also calculates metrics such as team velocity, workload, completion rate, and scope changes directly within the report, so you can save time and reduce manual calculations.

 

Let me know if you’d like guidance setting up the filters or exploring the Sprint Performance Report further!

Add-ons developed by my team.

Have a nice day and happy sprinting 🥳

[Bandarupalli Sai]

@Sian Snook you can set up a custom filter and use a gadget on a Jira dashboard to visualize the data. Here is my proposed solutio

• Create a Filter for Committed Work & Completed Work:
  Go to Issues > Search for Issues.
• Use the following JQL to capture all issues committed to the sprint:
  project = <project key> AND Sprint IN openSprints() AND statusCategory IN ("To Do", "In Progress", Done)
• This JQL will show all issues that were included in the sprint, regardless of their current status. Save the filter
• Go to Dashboards > Create New Dashboard (or edit an existing dashboard).
• Add a gadget such as Two Dimensional Filter Statistics or Issue Statistics.
• Configure the gadget: Select the Saved filter to display all issues taken into the sprint.
  
  Two Dimensional Filter Statistics gadget - Displays X-axis (Assignee) & Y-axis (Status) along with total issue count. Below is the gadget configuration

Issue Statistics gadget - Displays status/count/percentage. Below is the gadget configuration

Hope this helps!

[Sian Snook]

Thanks for the tips:

I've used this JSL : 

project = "231_cegard Smart FSP"

AND sprint IN (2100, 2079)

AND statusCategory IN ("To Do", "In Progress", Done)

As only want to See Sprint 20 & Sprint 21.

But its still seem to bring back other sprints?  why this?

Also is there a way of putting these numbers into a graph?

[Bandarupalli Sai]

@Sian Snook - Don't use sprint in Y-axis, group it by assignee or any other field to view only the issues form those specific sprints.

The Two Dimensional Filter Statistics gadget in Jira displays all sprints from the project if you use the "Sprint" field as one of the axes. Unfortunately, the gadget itself does not allow you to filter out specific sprints directly within its configuration.

If the answer resolved your query, could you please mark it as accepted? This helps others in the community find solutions more easily 

[Sian Snook]

I seem to have 2 small problem could you help please.

here is the JQL project = "231_cegard Smart FSP" AND sprint IN (2100, 2079, 2051, 2012, 2050)AND statusCategory IN ("To Do", "In Progress", Done)

Just have 2 more problems.

1). For Sprint 18 : the completed issue were 32 from the Sprint report but in the dashboard its 21 on Total Unique Issues: so 1 missing?? . Also done = 21 + cancelled = 7 there only 28? Why are the numbers not adding up?

2) The same as above for Sprint 17 has Total Unique Issues 112. Done = 90 But in the Sprint report = 38 "

[Sian Snook]

Here is the data

[Danut M _StonikByte_]

Hi @Sian Snook,

I'm afraid that it is not possible to display such chart / report directly by using the Jira out-of-the box tools. You could try the Jira's Velocity report, but it cannot display a "% of Delivery" series. 

My advice is to search on Atlassian Marketplace for an app that is capable to display such chart in real time. This will save you a lot of time and effort.    

If you are open to the idea of using an app, our Great Gadgets app could be the ideal solution. It offers Team Velocity gadget that is capable to display the chart you need.

In addition, this chart can display a Data table with many other useful number, which you can easily export in CSV format.

So this will fully satisfy your needs. And all the numbers will be in real time, without the need for additional work.

Find more about this gadget in this article: 8 gadgets for a powerful Scrum dashboard in Jira 

Danut.

[Rahul_RVS]

Hi @Sian Snook 

If you would be interested in a mktplace app, pls do take a look at 
Sprint Velocity & Status Gadgets 

The app comes with few dashboard gadgets to track team member's / team's velocity / productivity based on story points / time spent / issue count in a sprint  and also track sprint status with multiple parameters. The app works for past / closed sprints too.

Disclaimer : I am part of the team which developed this app