Count of issues which are mapped to custom field has sprint property

Questions & Answers
,
1

Hello Team,

we have custom field similar to “sprint” in our Project.
we wanted to count number of issues where “custom_Field_Sprint” has mapped to Current active sprint in project dimension

Pls support

Regards
Balaji

2

Hi,

If you have another field (e.g., “Another sprint”) having the same values as sprint names, the following formula should find the number of issues that are related to the custom field value with the same name as the active sprint in the project:

([Measures].[Issues created],
StrToMember(
  "[Another Sprint].["||
  Filter([Sprint].[Sprint].Members,
  [Sprint].CurrentHierarchyMember.get('Status')="Active" AND
  ([Measures].[Issues created],
   [Time].CurrentHierarchy.DefaultMember)>0
  ).item(0).GetCaption
  ||"]"
)
)

Kindly,
Janis, eazyBI support