Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

EazyBI - Transition from Status A to Status B - under condition

Ale I'm New Here Oct 04, 2021

Hi guys,

I hope you can support me with this one: I have a list of issues that may transition both from Status A --> Status B --> Status C and from Status C --> Status B --> Status A.

I have a table in which I want to show the date in which my issues have transitioned from Status A to Status B.

At the moment, I'm doing it by creating a new calculate measure called "Transition to Status B", that looks like this:

([Measures].[Transition to status last date], [Transition Status].[Status B])

The problem with this formula is that it shows the date in which the issue has transitioned to Status B, even if after this transition, the issue has transitioned back to Status A.

What I want to obtain is to have the date shown only if:

- The transition from Status A to Status B has happened, AND

- The issue is currently in Status B (or following. e.g. Status C)

I want the cell to be empty in case:

- The transition from Status A to Status B has never happened, OR

- The transition has happened AND the issue is in Status A.

How can I correct my formula to make it work properly?

Thanks for you help ;)

1 answer

Hi @Ale

For your calculation, you might want to use the dimension "Tranistion" that covers both statuses of transition, from and to. this way, you can find issues that had a particular transition [Transition].[Status A = > Status B].

On the other hand, to filter issues by their current status (Status B or Status C), you might use the dimension "Status".

 

1) In the "Status" dimension, create a new calculated member "B and C" to group statuses in which issue should be, Status B and Status C.

Aggregate({
  [Status].[Status B],
  [Status].[Status C]
})

More details on calculated members in dimensions are here: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-members-in-other-dimensions

 

2) In Measures, you can create a calculated measure showing the last date when the issue transitioned from Status A to Status B and is currently in Status B or Status C. For the calculation, use a tuple like this:

([Measures].[Transition to status last date],
[Transition].[Status A => Status B],
[Status].[B and C])

More details on calculated measures and a tuple construction are here: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures

 

Best,

Zane / Support@eazyBI.com

Ale I'm New Here Oct 06, 2021

Hi Zane,

thanks a lot!

Meanwhile I've solved it by using the following formula:

IIf(
[Measures].[Issue status] = "Status B"
OR
[Measures].[Issue status] = "Status C",
([Measures].[Transition to status last date], [Transition Status].[Status B]),
NULL
)

 I think the result is the same, even if your solution looks a bit more straightforward to me. I'll definitely try it.

Thanks & regards

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Partner Webinar Opportunities: January 2022

Hi everyone 👋, I really like the format of the webinar opportunities summary that @Jimmy Seddon posts monthly on the Welcome Centre group. It's a great place to go to check that you didn...

133 views 3 11
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you