Drill down to Sub-Task from Epic Link in eazyBI

Hi

I have a report which shows a table of issues that can be filtered on Epic Link.

Within a given epic I have Stories and sub-tasks - however, when filtering on Epic Link, I can only drill down as far as Story level.  

In the example below Story ISD-523 has a sub-task - there is an icon to expand - but you cannot expand any further (if you see what I mean).

So, how can I filter on Epic Link all the way from the top to the bottom of the tree?

Is it because sub-tasks do not inherit the Epic Link of the parent Story?  Is there a way around this?

 

image2016-7-25 9:42:0.png

 

1 answer

Hi Graeme,

yes, you are quite right - it is because of sub-tasks do not inherit the Epic Link of parent Story. I could not imagine how to avoid this restriction using Epic Link dimension as a Page filter.

Issue dimension Epic hierarchy Epic level members are the same as Epic link members. Therefore, as a workaround, you could create a calculated measure returning the Epic level issue name for all Issue dimension Epic hierarchy level members (from epic itself to sub-tasks) and then filter by this column to get only particular epic with all its stories and subtasks.

The calculation for such a measure could be the following:

 

CASE WHEN
  [Issue.Epic].CurrentMember.Level.Name matches 'Epic|Parent|Sub-task'
THEN
  Ancestor([Issue.Epic].CurrentMember, [Issue.Epic].[Epic]).Name
END

 

For more detailed assistance, please, contact support@eazyBI.com .

 

Ilze,

eazyBI Customer Support Consultant

 

 

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,233 views 14 19
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot