EazyBI - Transition from "B" to Status "A" History

[Lars]

Hey, 

i guess my problem is pretty easy to solve but im not able to get it working.

I have the following code:

NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
([Measures].[Transitions to status issues count],
[Transition Status].[Ready for IT Review])>0
AND
([Measures].[Transitions from status issues count],
[Transition Status].[In Business Analysis])>0
)
)
)

What i already have is a graph which shows the transition history of Status "A". Now I want to Show the "single" transitions to this status. e.g. In January 5 Issues went to that certain status. Somehow this code doesnt show the correct value as the graph does not fit. Any suggestions on that? I also thought about some Data Issues instead of Problems with the code.

Regards,

Lars

[Ilze Leite-Apine - eazyBI]

Hi Lars, 

you may want to try using "Transition" dimension (instead of "Transition status" dimension) together with a measure "Transitions to status issues count" in the report. Then you will easily get a number of issues having this specific transition Status A => Stats B without additional calculations, just by selecting this transition from the dimension (as a Page filter or in the report rows/columns). 

Add Time dimension to the report if you need to get the number by days.

Ilze, support@eazybi.com