Epic links - additional details on the epic

Questions & Answers
1

Hello,

I have an issuetype called Impediment which is linked with an epic by the epic link. I need to construct a report where I can get the details of the impediment + the details of the epic is it linked. Ideally I want to get certain custom fields of the epic.
Can this be achieve please? Or maybe there is another way apart from epic link that this can be done?

Thanking you for your help.

image
image1355×352 15 KB

image

2

Hello @Narsh,

You might retrieve the properties from the linked issue dimension directly via .Get()

[Epic Link].CurrentHierarchyMember.Get('Created at')

An alternative option is to use the Epic hierarchy from the Issue dimension.
Then you might filter the Impediments by page filters and retrieve their properties directly and access their parents (Epics) via .Parent method or Ancestor() function.

Retrieval of the parent epic fields might then be similar to the following.

Ancestor(
 [Issue].CurrentHierarchyMember,
 [Issue].CurrentHierarchy.Levels("Epic")
 ).Get('Created at')

Regards,
Oskars / support@eazyBI.com

3

Hello Oskars,

Thanks for your reply. I am struggling to get the correct formula as you mentioned.
Is it possible to give me the formula to get the status of the impediment or maybe the value of a custom field named ‘Targeted Quarter’ of the impediment please?

Thanking you in advance.

Regards,
Narsha

4

Hi @Narsh,

If you put Impediment in the report rows as a standard issue, you might use the standard “measures” like “Issue Status” or “Issue Targeted Quarter” from the Issue properties section of the Measures dimension.

Please clarify what issue holds the relevant property and which issue you are displaying in the report.

Regards,
Oskars / support@eazyBI.com