To list linked issues sideways

Questions & Answers
1

eazybi
eazybi965×169 6.48 KB

Hi,

Is there a way to list the linked issues on the side as shown above?
I wish it were row numbering but I don’t think it’s possible.
And I’m thinking about a few solutions, but I’d like to ask if i can make them like the example above.

2

Hi,

Such a solution is possible, and there can be a couple of possible solutions.
The first step is to import the issue links as described here: Import issue links - eazyBI for Jira.

Depending on the link import, some custom formulas will be needed to access the linked issues’ properties and group them by the project of linked issue. We have a training account where you may look for some measures in similar use cases: Analyze - eazyBI Demo Training - eazyBI.

Here comes the formula from my test example where the issue is related to bugs from different projects. The formula gives the assignee of the related bug:

NonEmptyString(Generate(Filter(
    [Issue].[Issue].GetMembersByKeys(
      [Issue].CurrentHierarchyMember.get('Bugs')),
      DefaultContext((
        [Measures].[Issues created],
        [Issue].CurrentMember,
        [Project].CurrentMember,
        [Time].CurrentHierarchyMember)) > 0
    ),
CoalesceEmpty([Assignee].[User].getMemberNameByKey(
  [Issue].CurrentHierarchyMember.get('Assignee name')),"(unassigned)"),
    ","
    ))

My report looked the following:

image
image1628×652 50.3 KB

Kindly,
Janis, eazyBI support