Count transition authors

Question

Hi!

I'd like to create a report in eazybi that shows transition to status issues count AND the count of transition authors of the above issue count. First part is done, but I cannot get a grasp on the latter as it always puts the count in the context of transition status. Is there a way to do this?

Thanks!

Tibor Kántor · Answer

Thanks Lauma! Works well!

Lauma Cīrule · Answer

Hi Tibor,

If you have the Transition Status on rows, you can use the 'Transitions to status issues count' Measure to get the count of how many issues have transitioned to the status. Further, you can create a new Measure with following formula that would count how many authors have done these transitions

NonZero(Count(Filter(
Descendants([Transition Author].CurrentMember, 
[Transition Author].[User]),
[Measures].[Transitions to status issues count] > 0
)))

Let me know if you have further questions regarding this!
Lauma / support@eazybi.com