Sprint Issues Committed+Added-Removed != Sprint Issues at Closing

Should not the measures Sprint issues committed + (Sprint issues added - Sprint issues removed) equal the measure Sprint issues at closing (and the same for Sprint Story Point measures)?

I’m getting a higher count from Sprint issues at closing. It is quite possible that the problem is dirty data but I just wanted to confirm my assumptions regarding the aforementioned calculations.

​Hello @AWPPMT

The short answer is “yes” - your logic is correct. Sprint issues at closing is a measure that counts sprint issues at the moment when the sprint was closed.
To make sure, I also checked on my data the comparison with measure “Sprint issues at closing” and a calculated measure:

[Measures].[Sprint issues committed]+
([Measures].[Sprint issues added]-
[Measures].[Sprint issues removed])

I did, however, find one instance where the numbers didn’t match in my data. When drilling through the issue, I noticed that one particular issue had gone through all the stages (committed, added, and removed from the sprint multiple times). The fact that it was removed and added to the sprint multiple times, most likely caused the inconsistency. I would recommend you do a similar check when you identify the inconsistencies and drill through those issues that cause the problem, to see if you can find a similar pattern for these cases.



​Please let me know if you have further questions regarding this!

Elita from support@eazybi.com