Count Assignees

[Alexis Bueno]

Is there a way to count the number of selected assignees that are being used as a dimension in pages for a calculated measure?

for example

(DateDiffWorkDays(DateParse([Time].[Day].CurrentMember.Name),
DateParse('Aug 1 2015'))) * ((count(# of assignees) * 4)

What I am trying to accomplish is days * (a count of number of selected assignees * 4 )

[Lauma · Accepted solution]

Hi Alexis,

Yes, this would be possible

• ChildrenSet function returns the children of aggregated Page member
• Count function counts how many members are in a set

Count(ChildrenSet(
  [Assignee].CurrentMember
))

Note that in case All Assignees are selected, this would return total number of members in Assignee dimension.

So your formula would be as follows 

DateDiffWorkDays(
  DateParse([Time].[Day].CurrentMember.Name),
  DateParse('Aug 1 2015')
) *
Count(ChildrenSet(
  [Assignee].CurrentMember
)) * 4

Kind regards, 
Lauma / support@eazybi.com 

[Krzysztof]

Hello Lauma

Is it possible to calculate how many unique assignees (or reporters) have been assigned to issues on for eg. monthly chart? On a chart with time dimmension in rows and issues created/issues resolved/open issues in columns i'd like to add a number of assignees related to each column.

Edit: to monitor dependence between growth of open issues and number of people involved in resolving them. So it should be a number of resolved issues assignees. But number related to created and open won't hurt:)

thansk in advance!

Chris

[Alexis Bueno]

Thank you again Lauma, this is exactly what I needed!