How to get "Transition from status first date" when presenting issues grouped by sprint

Questions & Answers
,
1

Hi Again

Problem:
When I group rows by Sprint, and add “Transition from status first time”, It does not start with the “absolutely first transition”, but is limited by the Sprint’s time interval.
The first issue’s absolute “first transition” is June 7th,

issue_10990_transition_list_and_sprint_view,png
issue_10990_transition_list_and_sprint_view,png966×562 47.1 KB

Thanks

2

Hi @AllanBentsen

Welcome back to the eazyBI community.

You need to ignore the sprint to get the absolute first issues transition. The formula might look something like this.

CASE WHEN
([Measures].[Sprint issues added]+
[Measures].[Sprint issues committed]) > 0 
THEN
TimestamptoDate(([Measures].[Transition to status first timestamp],
[Sprint].CurrentHierarchy.DefaultMember))
END

Kindly,
Ilze

3

Thank you Ilze,
I will give it try.