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