My request is to get total Hours Spent from two JIRA project, I’m trying to create a calculated member as picture shown, but I don’t know how to get second part of formular, please help me to finalize the formular, many thanks.
Part 1: All hours Spent in LHRD201603 PEP project;
Part 2: All hours Spent in a Epic named “LHRD201603 PEP” in another project named LHRD202001 MVD (a software project to support all project requirements, this project used Epic to split different project)
I had found the correct formular, share for similar requester as below:
Sum(Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
[Issue].[Issue].GetMemberByKey([Measures].[Issue parent key]).GET('Feature Link') = 'LHRDPEP-12'
)
this formular will help to get all hours spent in an Epic.
1 Like
Hi @Matt_Z,
GetMemeberByKey() is an excellent function allowing yuo to access data from related issues =)
If issues are organized in a hierarchy, like Epic or Parent hierarchy, there is an alternative solution with the tuple expression. The expression might look like bleow:
(
[Measures].[Hours spent],
--precise feature name in the epic hierarchy,
[Issue.Epic].[LHRD202001 MVD].[LHRDPEP-12]
)
Best,
Zane / suport@eazyBI.com