Count Colaborators in issue

Questions & Answers
1

Hi,
Is there any way to calculate how many people has workloads in an issue.

thanks

2

Hi @aelexpuru ,

You can create a calculated measure in the Measures dimension. Use Count() and iterate through Logged by dimension members, and add the function Filter() and Hours spent as filtering criteria. The measure would define how many users have logged hours per issue.

Here is the formula:

NonZero(Count(
  Filter(
    DescendantsSet([Logged by].CurrentMember,[Logged by].[User]),
    --related to time dimension by time spent start date
    [Measures].[Hours spent] > 0
  )
))

best,
Gerda // support@eazybi.com

3

Thanks @gerda.grantina

1 Like