Amount of Storys by Sprints to completion

LeoDu · May 23, 2022, 11:28am

Hello Everyone,

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

LeoDu

roberts.cacus · June 13, 2022, 9:24am

Hi @LeoDu,

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:

NonZero(Count(
  Filter(
    [Sprint].[Sprint].getMembersByKeys(
      [Issue].CurrentHierarchyMember.get('Sprint IDs')
    ),
    [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.

An alternative is defining a new JavaScript calculated custom field that will calculate the number of Sprints for all imported issues. You can import it as a dimension and select it in the report rows. See the suggested parameters below and add them to the eazyBI advanced settings:

[jira.customfield_sprintCount]
name = "Number of Sprints"
data_type = "string"
dimension = true
javascript_code = '''
if(issue.fields.customfield_NNNNN){
  issue.fields.customfield_sprintCount = issue.fields.customfield_NNNNN.length
};
'''

Replace 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:

Best,
Roberts // support@eazybi.com