Custom Sprint metrics

Questions & Answers
2

Hi @rolandas.kicas,

Welcome to the eazyBI community!

I am happy you tried to create the calculated measures for the missing metrics on your own. Please have a look at our Demo account. There is one particular example that could fit your use case - https://eazybi.com/accounts/1000/cubes/Issues/reports/243468-sprint-issue-balance. It has the measure “Sprint issues completed of committed”, which displays the number of resolved issues from the original commitment. Please try to alter the formula to use the number of Story points instead:

-- this measure will calculate the resolved issues in the last Sprint where an issue was committed and finally resolved
-- this measure excludes committed and completed issues if they were reopened after sprint completion and were resolved in later Sprint or outside of Sprint
CASE WHEN
    [Sprint].Currentmember.Level.name = "Sprint"
THEN
  NonZero(SUM(
    Filter(
      Descendants([Issue].Currentmember, [Issue].[Issue]),
       [Sprint].CurrentMember.Name = [Measures].[Issue Sprint]      
      ),
      CASE WHEN
      [Measures].[Sprint Story Points committed] > 0
      THEN
      [Measures].[Story Points resolved]
      END
  ))
END

Please try to create the calculated measure, to calculate the added resolved Story points.

The Sprint dimension DefaultMember in your calculated members likely caused the measure malfunction with Sprint dimension on rows.

The measure “Sprint Story Points added” calculates the number of Story Points that were in issues that were added to the Sprint while it was “Active”.
The “Sprint Story Points commitment change” displays the difference in Story Points at the end and the beginning of the Sprint.

If a Story was in the Sprint before its beginning (Sprint Story Points committed), but the value of Story Points was changed, those will fall into “Sprint Story Points commitment change” not in “added” or “removed”.

Please have a look at our documentation page for more information on all the Sprint scope measures - https://docs.eazybi.com/eazybijira/data-import/data-from-jira-and-apps/jira-software-custom-fields#JiraSoftwarecustomfields-Sprintscopemeasures.

Best,
Roberts // support@eazybi.com