EazyBI calculated member

Roman Osatinski December 10, 2021

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
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 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.

0 votes
Daina Tupule eazyBI
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 14, 2021

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
AUG Leaders

Atlassian Community Events