Individual ticket number and Team ticket numbers

Questions & Answers
1

I want to create a new measure for team total ticket count in done status.
Individual ticket number / Team ticket number

Let’s say I have 3 people in a Project.

People A : 3 tickets
People B : 2 tickets
People C : 1 tickets

I want to create a measure to calculate

People A: 3/( 3+2+1)
People B: 2/( 3+2+1)
People C: 1/( 3+2+1)

NonZero(Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Issues created] > 0
AND
[Board].CurrentMember.Name = “Scrum Board”
AND
[Measures].[Issue status] = “Done”
)
))

It still return the number by individual.

Please help.

Thanks.

2

Hi, @wing

To create the new measure for individual results divided by whole team results, please consider using the measure Issues resolved.

The formula should look like this:

[Measures].[Issues resolved]
/
(
[Measures].[Issues resolved],
[Assignee].CurrentHierarchy.DefaultMember
)

Kindly,
Ilze support@eazybi.com