Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,637,836
Community Members
 
Community Events
196
Community Groups

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

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

1 vote
Zane eazyBI Support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Oct 05, 2021

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

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

Like Karina Stoute likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events