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 
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
Something like this:
Aggregate(
Filter(
[Transition].[Transition].Members,
[Transition].CurrentMember.Name matches "Backlog => .*"
)
)
Martins / eazyBI
@martins.vanags
Hello, I am trying to add all the tickets that were returned to the backlog status in a month, for that I have the following measure
sum((
Filter(
[Transition].[Transition].Members,
[Transition].CurrentMember.Name matches “.* => Backlog”
)
),[Measures].[Transitions to status])
However, eazybi tells me that it is too complex for analysis and I don’t know how else I can approach it, can you help me?
Try the following code:
(
[Measures].[Transitions to status issues count],
[Transition Status].[Backlog]
)
Martins / eazyBI
This measure gives me the number of issues that were created that month. I need the ones that were returned to the backlog status.
Former:
develop in progress => backlog
+
analysis in progress => backlog
for any state of my flow
Try this formula.
(
[Measures].[Transitions to status issues count],
[Transition Status].[Backlog]
)
-
(
[Measures].[Transitions to status issues count],
[Transition].[=> Backlog]
)
Martins
Hi @martins.vanags
There is a way to use this measure but it does not calculate the transitions of the same ticket (if this step twice only counts me once)
You are right, this calculation won’t calculate the transitions of the same ticket.
You can try using “Transitions to” and “Transitions from” to count all the transitions for a ticket, but then it would require that you select “Issue” dimension somewhere in the report context.
Martins
