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?
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.
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.
[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 / email@example.com
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...
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