Cannot see right transition status at the last day of the Sprint

Questions & Answers
1

Hello,

I created a report that shows the number of issues in status at the end of every day

On the last day of the Sprint, I see Zero for some issue and I cannot find the reason for it.
Please, help me.

The report

image
image1110×607 31.3 KB

Focusing on one example of Issue

image
image835×306 16.8 KB

and if I remove Sprint from the row - I will get

image
image841×313 15.7 KB

I really appreciate any help you can provide.
Dima Kostiuk

2

Hi,

The likely reason for showing zeros on the last day of the sprint is that eazyBI automatically removes tickets not completed to (no sprint) once the sprint is closed.

Issues history gives the count of issues at the end of the selected period (day), so if you close the sprint on October 27, there is zero unresolved issues in the sprint at the end of the day.

The workaround for your report is to combine the Issues history with a measure that is specifically designed to show data at sprint closing.

The following formula should do that:

CASE WHEN
 DateInPeriod([Measures].[Sprint end date],
    [Time].CurrentHierarchyMember)
THEN
 [Measures].[Sprint issues at closing].value
ELSE
 [Measures].[Issues history].value
END

Kindly,
Janis, eazyBI support

1 Like
3

Thank you

it is better to use
[Measures].[Sprint actual end date]