Need count of issues transitioned to failed status from set of different start status

I’am very new to EasyBI and tried modifying existing report but i guess i will need to create a calculated measure for the same.How to get a count of issues(epics,stories,bugs) which have transitioned from a set of either of the below three transitions over a specific time period/ year?

Ready to deploy to failed
Ready for testing to failed
Done to failed

Any help for the same is appreciated

Hi,

eazyBI data cube has the Transition dimension, which is helpful for your use case.
Please, create a calculated member in this dimension with a formula like this:

Aggregate(
  {
  [Transition].[Ready to deploy => failed],
  [Transition].[Ready for testing => failed],
  [Transition].[Done => failed]
  }
)

Now, the following formula gives the number of issues with any of the transitions during a period:

([Measures].[Transitions to status issues count],
[Transition].[Failed transitions])

The transition name Failed transitions refer to the aggregated member.

Kindly,
Janis, eazyBI support