i am currently trying to show, what percentage of Stroys where completed in how many Sprints.
We currently got Storys, that needed up to 5 Sprints, but also fast ones, which where finished in only one Sprint.
I would like to get an overview over the amount of Storys finished in 1,2,3,4,5 … Sprints.
Do you have an Idea how to solve this?
Thank you for your help and best regards
One way to approach this is by defining a calculated measure that counts the number of Sprints instead of listing their names. The formula could look similar to the one below:
[Sprint].CurrentHierarchyMember.Key > 0
The calculated measure will return results with the Issue dimension “Issue” level members in rows. See an example below:
You can order the report rows to reveal the issues with the most Sprints.
name = "Number of Sprints"
data_type = "string"
dimension = true
issue.fields.customfield_sprintCount = issue.fields.customfield_NNNNN.length
NNNNN with the ID of the Sprint custom field. Then, after updating the eazyBI advanced settings, select the “Number of Sprints” custom field for import in the eazyBI import options “Custom fields” tab. The report then could look similar to the one below:
Roberts // email@example.com