Sprint Planned vs Actual

Questions & Answers
1

I want to show the number of issues planned in the sprint vs. actual completed.
For issues planned I created a calculated field.
If the sprint is closed or active, Sprint Issues Committed is used.
How do I show the number of issues belonging to future sprints? I tried Issues Created but it is not giving the correct number.

CASE [Sprint].CurrentMember.get(‘Status’)
WHEN “Closed” THEN [Measures].[Sprint issues committed]
WHEN “Active” THEN [Measures].[Sprint issues committed]
ELSE [Measures].[Issues created]
END

image
image741×655 33.3 KB

2

Hi @Howell ,

The measure “Issues created” should return the correct number for future Sprints. How did you determine that it isn’t correct in your particular situation?

Best,
Roberts // support@eazybi.com

3

Hi Roberts,

You are right! After rechecking the data the figures are coming out correctly.
Thanks!

Regards,
Howell

1 Like