Hi!
i would like to calculate Issues completed outside of this sprint the same as in jira sprint report ,in order to reduce this amount of tickets from the committed tickets in sprint
this function gets me wrong numbers:
([Measures].[Sprint Issues committed],
[Transition Status.Category].[Done])
Trying to find the amount of tickets completed at the moment the sprint was closed
any ideas?
Hello @Anna_Chernov
Welcome to eazyBI community!
The formula you sent (pasted below), will show the issues that have been in the Status Category “Done” at the moment when sprint was started (committed issues are issues that have been assigned to the sprint at the moment the Sprint got activated/started).
([Measures].[Sprint Issues committed],
[Transition Status.Category].[Done])
Could you please clarify with an example, how you would like the formula to work?
For the last part of your message “Trying to find the amount of tickets completed at the moment the sprint was closed” - you could use Measure “Sprint issues completed”.
You can learn more about Sprint Scope Measures here - Jira Software custom fields
Best wishes,
Elita from support@eazybi.com