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
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.