All eazyBI for Jira eazyBI for Confluence Private eazyBI

Sprint issues by status category at sprint end
eazyBI for Jira

On this page:

Overview

The report displays the status category for the issues when 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 the "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 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 is still active and will filter the last ten closed sprints in the report. 

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

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

In Pages, select the 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 the "By type" hierarchy to filter issues by Standard issue types. Also, add a "Sprint" dimension in "Pages" and filter all Closed sprints.

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

See also