nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Ilze Leite-Apine - eazyBI

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

All comments

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.

Ilze Leite-Apine - eazyBI

Hi @Chawn Corrales - Rodriguez

([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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

eazybi