Transition From Any status to one

Hello
i want to count transitions to a specific status but it can be made from several statuses. for example:

[Transition].[Backlog => Interested / To be Qualified]
[Transition].[Searching Champion => Interested / To be Qualified]
[Transition].[Contacted / Needs follow up => Interested / To be Qualified] and etc

can i combine them? like - [Transition].[Any => Interested / To be Qualified]

Hi @shaok

Welcome to eazyBI community :slight_smile:

In this case, you could create a new calculated member in “Transition” dimension using the following code example:

Aggregate(
Filter(
[Transition].[Transition].Members, 
[Transition].CurrentMember.Name matches ".* => Interested/ To be Qualified"
)
)

Then you can select this calculated member in your reports when using the “Transition” dimension and from “Measures” dimension you can select the predefined measure “Transitions to status” or “Transitions to status issues count”

Martins / eazyBI team

Hello,
In the case of knowing the issues that come from one state to another, how would the code be formulated.

Ex: Backlog => Any state

@Marcelo_Ignacio_Cid1

Something like this:

Aggregate(
Filter(
[Transition].[Transition].Members, 
[Transition].CurrentMember.Name matches "Backlog => .*"
)
)

Martins / eazyBI

1 Like