Translating a JQL with linked issue function to calculated measure

[dIVYA:SUNDARESHAN]

Hi all,

I need some help translating this JQL to a calculated measure in eazyBI report so that i can filter issues based on labels of linked issues

issueFunction in linkedIssuesOf(“type in (‘L1 Technical Feature’, ‘L2 Technical Feature’) and labels= PI2025.5”, “is implemented by”)

Thanks in advance

[Christos Markoulatos]

Hi @dIVYA:SUNDARESHAN 

Easybi uses MDX, check the documentation:

Calculated measures

Something like 

CASE WHEN

  Count(

    Filter(

      [Issue].[Issue].GetLinkedMemberNames("is implemented by"),

      [Issue].[Issue].CurrentHierarchyMember.get('Issue Type') MATCHES "L1 Technical Feature|L2 Technical Feature"

      AND

      [Issue].[Issue].CurrentHierarchyMember.get('Labels') MATCHES ".*PI2025.5.*"

    )

  ) > 0

THEN 1

ELSE 0 END

should work i believe, haven't tested it though