EazyBI - I want to show when something moves from "In Progress" to "Backlog".

[Chawn Corrales - Rodriguez]

I have a warning in place to show when issues are past due, late start, or Early Close (below). I just can't figure out how to show when the status changes happen. Can anyone help?

CASE
WHEN [Measures].[PlannedEndCompare] = 1
AND [Measures].[Issue resolution] = 'Done'
THEN 'Early Close'
WHEN [Measures].[PlannedStartCompare] = -1
AND [Measures].[PlannedEndCompare] = 1
AND [Measures].[Issue status] <> 'In Progress'
THEN 'Late Start'
WHEN [Measures].[PlannedEndCompare] = -1
AND [Measures].[Child Resolution Progress] < 1
THEN 'Past Due'
WHEN [Measures].[PlannedStartCompare] = 1
AND [Measures].[Issue status] = 'In Progress'
THEN 'Early Progress'
END

[Ilze Leite-Apine - eazyBI · Accepted solution]

Hi @Chawn Corrales - Rodriguez 

You can check if the issue has gone through a particular transition by using a condition with tuple from dimension "Transition" and measure "Transitions to status" (more about this dimension and measure), i.e. if the count of such transitions is larger than 0:

([Measures].[Transitions to status],
[Transition].[In Progress => Backlog])>0

Best,

Ilze, support@eazybi.com

[Chawn Corrales - Rodriguez]

This is incredibly helpful!

Though to add a layer of complexity. Can I make it say something other than true or false?

[Lauma Cīrule]

@Chawn Corrales - Rodriguez

You can add this in a CASE or IIF statement, e.g.

IIF(
([Measures].[Transitions to status],
[Transition].[In Progress => Backlog]) > 0, 
'Yes', 'No' )

Lauma / support@eazybi.com

[Chawn Corrales - Rodriguez]

I'm so glad I asked this forum! Thank you both so much for your help. This did exactly what I was looking for. 

[Joe Pitt]

I'm not familiar with EazyBI, but it appears you are looking at data values. When a transition moves the issue history will show it, but probably nothing you can measure. You can use a post function in the transition to set the value of a custom field. I do that to set the date for milestone transitions. You would need to modify the workflow and create a custom field to do that. Maybe someone familiar with EazyBI has a solution 

[Chawn Corrales - Rodriguez]

Thanks for getting back to me! I couldn't find an option for EazyBI in the dropdown so if there is a better place for this question I'll move it there.