Iam trying to get the no of defects reported against the story points working by a specific assignee

Questions & Answers
, , ,
1

Need help with this

image
image546×114 4.73 KB

Note the defect issue type is a subtask of the story

2

Hi @Santosh,

Welcome to the eazyBI community!

If you don’t need to verify the sub-task issue type, you can iterate through issues that have Story Points and return the number of sub-task in them with the following calculated measure:

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    -- consider issues with sub-tasks
    Not IsEmpty([Issue].CurrentHierarchyMember.Get('Sub-task keys'))
  ),
  -- consider issues with story points assigned to the particular Assignee dimension member
  CASE WHEN [Measures].[Story Points created] > 0
  THEN
  -- count the number of sub-tasks in those issues
  Len([Issue].CurrentHierarchyMember.Get('Sub-task keys')) - Len(Replace([Issue].CurrentHierarchyMember.Get('Sub-task keys'), ',', '')) + 1
  END
)

The calculation won’t consider the assignee of the sub-tasks. Refer to the eazyBI documentation page for more information on defining calculated measures - ​Calculated measures and members.

Best,
Roberts // support@eazybi.com