Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

Edited

I need help with putting together an EazyBI calculated member to show the sprint date of a dependency.

For example: Issue 1 depends on issue 2. I would like to show Issue 2 sprint date/name in the row for issue 1 showing that linkage. 

On the same topic, is there a way to show the dependency due date pulled from issue 2?

2 answers

1 vote
Fabian Lim Community Leader Dec 10, 2021

Hi @Roman Osatinski

You can find some good examples on the second point here: https://community.eazybi.com/t/report-linked-issues-of-any-type/149

For the first one it's possible as well and if you are paying for the subscription, contact their support team and they will help you.

Hi @Roman Osatinski 

 

You would like to import linked issues into eazyBI. While eazyBI supports linked issue import, you would like to specify what linked issues you would like to import. You can define several linked issue imports for different scenarios.

See our documentation on linked issues and this eazyBI community tips and tricks post for issue linking describing link import in more detail. 

After import, you can address those linked issues in your reports. You might need formulas for this.

Here are example formulas to get the sprint and due date from a linked issue. Both examples will use a default imported link value - representing the parent issue for the sub-task. 

Parent Sprint

[Issue].[Issue].GetMemberByKey([Issue].CurrentHierarchyMember.get('Parent issue key')).Get('Sprint')

Parent due date:

[Issue].[Issue].GetMemberByKey([Issue].CurrentHierarchyMember.get('Parent issue key')).GetDate('Due date')

The formulas might be more complex if you have several linked issues (imported with option multiple_values = true). You can check out  example formulas based on the multiple-values link field Bugs (representing linked Bugs to stories). In this case, you would like to show all values or the last/first value based on some rules. You would like to replace the link field name Bugs 

In the formulas above, Parent issue key represents the link field name, the example reports in our demo training account use link field Bugs. You can use any of the examples, remember to switch to your field names. Please use MDX autocomplete to fill in any field names. 

 

Daina / support@eazybi.com

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

529 views 19 25
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