Average number of Transitions per a dimension/group

Questions & Answers
1

Hi there,

I am trying to calculate the average number of Transitions per internal assignee and also per assignee as displayed in the below screenshot.

image
image1476×371 11.2 KB

Here, I want a column that displays the average number of transitions (To do -> In Progress) per “Internal assignee”.

For example:

Adam-
*the average number of To Do -> In Progress transitions would be (2+2)/2 = 2,
*the average number of In Progress -> In Rework transitions would be blank

Brandon - It will be (1+1+1+1)/4 = 1 and blank respectively.

Similarly, I would need it per “Assignee” as well.
So, for James, the average number of To Do -> In Progress transitions would be 9/8 = 1.125
the average number of In Progress -> In Rework transitions would be blank 2/8 = 0.25

Could you please help me out here. Is this possible? or should it be the other way?

Thanks,
Keerthana.

2

Hi,

Try creating a new calculated measure using this code:

NonZero(
Avg(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Transitions to status]>0
),
[Measures].[Transitions to status]
)
)

It would calculate the average result of issue transitions for any level where it is applied.
Then you could remove the “Issue” dimension from your report and see average results per assignee.

When selecting this measure, make sure that " Nonempty " cross join is enabled to optimize the calculation steps in this calculation.
https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-Pagedimensions

Martins / eazyBI support