Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

eazyBI calculated member to replicate value

I am trying to create an eazyBI calculated member to replicate a value from a different Issue. Conceptually, I want to accomplish the following:

[Issue].CurrentMember.get('Epic Link')

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? 

1 answer

Hi David,

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.

[Issue].[Issue].GetMemberByKey([Issue].CurrentHierarchyMember.get('Epic Link'))

 

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')

I just saw this now. Thank you for your help. I tried the examples you provide to define a calculated member formula and wasn't able to get any data to show. Any thoughts?

20170307-easybi.jpg20170307-easybi2.jpg

Hi David,

 

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 support@eazybi.com for more detailed and extensive answer If you would like to get some results in the report with your configuration?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Happy New Year and Welcome New Marketplace Partner Program Partners!

Happy New Year! We hope you all had a safe and restful holiday season. 2020 was a unique year full of unforeseen events; however, as we enter the new year of 2021, we’re optimistic for the light at t...

509 views 7 18
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you