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

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

Focusing on one example of Issue

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

I really appreciate any help you can provide.
Dima Kostiuk

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

Thank you

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