Count issues by user key

Questions & Answers
1

Hello everyone,

Our jira users are: internal001, internal002… external001, external002…
Now I want to count: every sprint, how many issues are assigned to internal users and external users.

Here is my ocde, but it could not work:

Count(
Filter(
Descendants([Assignee].CurrentHierarchyMember, [Assignee].[User]),
[Assignee].[User].getMemberByKey(CurrentUser()) MATCHES “^internal^”
)
)

Could anybody help me?

Hugo Wu

2

I improved it to:

Count(
Filter(
Descendants([Assignee].CurrentHierarchyMember, [Assignee].[User]),
[Assignee].CurrentHierarchy.Key MATCHES ‘^internal.*’
)
)

It seems the result it not correct, so I want to add: [Measures].[Sprint issues at closing]

But I do not know how to do, could anybody help me?

Hugo Wu

3

Hi,

You are almost there! The only thing: using function Count(), you are counting filtered assignees, not issues. To get the sum of sprint issues over those assignees, use the same filtering logic, only with Sum() aggregate and using [Measures].[Sprint issues at closing] as a numerical expression:

Sum(
 Filter(
  Descendants([Assignee].CurrentHierarchyMember, [Assignee].[User]),
  [Assignee].CurrentHierarchy.Key MATCHES "^internal.*"
 ),
 [Measures].[Sprint issues at closing]
)

You may use any other Sprint scope measure as numeric expression if you want to get the count of completed or committed assigned issues etc.

Here is more about Sum(): https://docs.eazybi.com/display/EAZYBI/Sum

Best,
Ilze, support@eazybi.com

4

Thank you for your help.
I got new knowledge from your side.

Hugo Wu