All eazyBI for Jira eazyBI for Confluence Private eazyBI

Sprint issues by status category at sprint end
eazyBI for Jira

On this page:


The report displays the status category for the issues at the moment the sprint was closed.

How to build it

To build this report, start with the table view and select the Sprint dimension in Rows, select "Sprint" level from the "By status" hierarchy to see the report information at the sprint level

In the Measures dimension, select measure Sprint issues at closing, "Last closed sprints by boards" and unselect default measure "Issues created". Measure Sprint issues at closing counts how many issues were at the moment when the Sprint was closed.

Filter the report rows by the measure Last closed sprints by boards with the condition "=<10". Remove the measure "Last closed sprints by boards" from the report view, the filter still is active and will filter the last 10 closed sprints in the report. 

Select option "Hide empty rows" to hide rows without data. 

Use Transition Status dimension in Columns and select "Category" level from the "Category" hierarchy. This dimension together with the measure "Sprint issues at closing" displays the historical status for the issues at the moment sprint was closed.

In Pages select dimension "Project" for filtering. When the sample report is created in eazyBI, eazyBI automatically selects the first project with report measures for filtering. Additionally add "Issue type" in Pages and select "All Issue Types by type" from "By type" hierarchy to filter issues by Standard issue types. Also, add "Sprint" dimension in "Pages" and filter all Closed sprints.

Then switch to the Bar tab and select Stacked and show Data labels from toolbox options. Change colors for "Status" dimension members.

See also