How to link issue cross project to sum worklog in Jira?

Hello,

We would like to sum all work log between two differents JIRA (cloud version) projects and three levels of links.

Project 1 : Story A
Project 2 : Epic B, Story C

  • Story A is the main ticket, which is link with “relates to” the Epic B.
  • Epic B is link as an Epic to Story C

I would like to have a report EazyBi like this:
Column 1:Summary of the Story A
Column 2: Worklog of the Story A
Column 3: Worklog of the Epic B
Column 4:Worklog of the Story C

Thanks in advance
Guillaume

Hi Guillaume!

To do this it is first necessary to import linked issue key as property to Story A in Project 1. Assuming that ‘relates to’ is inward link for Story A, the eazyBI advanced settings for the Relate link type would be as follows

[jira.customfield_relate]
name = "Relate"
inward_link = "relates to"

After you have updated the advanced settings, select the ‘Relate’ link custom field for import in eazyBI source data tab. Note that for the below formulas to work, both projects need to be imported into the account.

Here is a report example:

The Hours spent is the default measure returning work logged for the ‘Story A’. Further, there are two calculated members that get hours for the relating issue - epic with key EXP-1

  • Relating issue hours spent

    DefaultContext((
    [Issue].[Issue].getmemberbykey(
    [Issue].CurrentHierarchyMember.get(“Relate”)).Item(0),
    [Measures].[Hours spent]
    ))

  • Relating issue story Hours spent

    DefaultContext((
    [Epic Link].[Epic].getmemberbykey(
    [Issue].CurrentHierarchyMember.get(“Relate”)).Item(0),
    [Measures].[Hours spent]
    ))

Please let me know if you have further questions regarding this!
Lauma / support@eazybi.com

Hello,

Many thanks, it works fine !
Does it sum if there are several link relates to ?
What does it mean “Item(0” ?

Thanks

Guillaume,

You are correct, it only would work in case there is one link. More general solution would be by using GetMembersByKeys(…) function. Please try following

  • Relating issue hours spent

    Sum(
    [Issue].[Issue].getMembersByKeys(
    [Issue].CurrentHierarchyMember.get(“Relate”)),
    DefaultContext((
    [Measures].[Hours spent],
    [Issue].CurrentMember
    ))
    )

  • Relating issue story Hours spent

    Sum(
    [Epic Link].[Epic].getMembersByKeys(
    [Issue].CurrentHierarchyMember.get(“Relate”)),
    DefaultContext((
    [Measures].[Hours spent],
    [Epic Link].CurrentMember
    ))
    )

Kind regards,
Lauma / support@eazybi.com

1 Like

For me it does not give any result , mine is a simple link “is Caused by”, i have updated the advance setting with “is caused by” and selected “relate” to import also. I have not used EPIC, so may be that’s the issue. its not able to create EPIC link as below error.

Hi @sushant.rout!

Yes, the problem here is that you do not have the Epic Link dimension, so you can’t get all hours logged to the related epic.
Could you please describe your case in more detail and what you are looking for?

Lauma / support@eazybi.com