I am trying to create an eazyBI calculated member to replicate a value from a different Issue. Conceptually, I want to accomplish the following:
Based on this link value, I want to look-up another Issue using this value as the key. Once I am able to load this issue, I would like to access a field within this Issue and assign its value to the current calculated member. How do I accomplish this?
You are using Epic issue key. eazyBI provides many options to work with different issue hierarchies. Please try Issue Epic hierarchy for your reports.
However, you can extend the usage as asked as well:
You can access any Issue member if you have an issue key with the function GetMemberByKey.
Then you can use this member in a tuple with a measure to access measures. For example, this tuple will retrieve you Original estimated hours set directly in Epic issue. I also used DefaultContext with this tuple to avoid an influence of currently selected issue:
DefaultContext(( [Measures].[Original estimated hours], [Issue].[Issue].GetMemberByKey( [Issue].CurrentHierarchyMember.get('Epic Link')) ))
With GET you can access any Epic property:
[Issue].[Issue].GetMemberByKey( [Issue].CurrentHierarchyMember.get('Epic Link')).get('Created at')
The formulas above work on Issue level only. Please add the Issue dimension to Rows and expand to Issue level.
Could you send more details about your report to firstname.lastname@example.org for more detailed and extensive answer If you would like to get some results in the report with your configuration?
Hi Atlassian community, I work on the product integration team at Atlassian and I am very excited to announce the early access program for the Jira Cloud add-on for Google Sheets. This add-on giv...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs