I need to count the number of unique tasks assigned to each sprint participant. For example: Task TOK-1 was assigned on users A, B and C.
And the TOK-2 task was assigned to A and B.
Then the metric value:
A - 2
B - 2
C - 1
Hi @EgorPolevoy , I am still learning EazyBi myself, but my try creating a new calculated measure as follows:
Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issue Assignee] = [Assignee].CurrentMember.Name
)
)
Cheers
Dave
Thanks but , not working
Hey there,
Do you have the Assignee Dimension at Rows and Issue Dimension at columns?
Maybe try this as a new calculated measure:
Aggregate(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issues created] > 0
)
)
Hi @EgorPolevoy ,
Welcome to the eazyBI Community
You can try using this formula to count how many issues were assigned to the user during the sprint. Use “Assignee” dimension on Rows and filter the report by the “Sprint” dimension in Pages:
NonZero(Count(
Filter(
DescendantsSet([Issue].CurrentHierarchyMember, [Issue].[Issue]),
Aggregate({
[Transition Field].[Assignee],
[Transition Field].[Sprint status]
},
([Measures].[Transitions to],
[Sprint Status].[Active])
)>0
)
))
Here is the final report:
Kindly,
Gerda // support@eazybi.com