Epics with "is blocked by" issues not working

New to EazyBI. Trying to set up a table that shows my one main Epic, which contains 115 ‘is blocked by’ links to it and then to organize it by status category that will show something like this:

EPIC-123
+ DONE (show all completed tasks)
+ IN PROGRESS (show all tasks that are currently in progress)
+ TODO (those tasks not yet started).

I have blocked by/blocks imported as measures.

Just cant seem to get the right logic in place to show this drill down method. Thx in advance!

Hello @petemo94

Welcome to the eazyBI community!

​Considering you have already imported issue links, please define a new calculated measure replacing “Your Dimension name” with the dimension and/or property you have imported as your issue links.

CASE
WHEN
[Status].CurrentHierarchyMember.level.Name = "Category"

THEN

Count(
Filter(
[Your Dimension name].[Your Dimension name].GetMembersByKeys(
[Measures].[Issue Your Dimension name]),
[Status.Category].[Status].GetMemberByKey(
[Your Dimension name].CurrentHierarchyMember.Get('Status ID')).Parent.Name =
[Status].CurrentHierarchyMember.Name

))
ELSE
Count([Your Dimension name].[Your Dimension name].GetMembersByKeys([Measures].[Issue Your Dimension name])

)
END


Once you have selected the measure, you can proceed with - drilling into status dimension → category

​Your result should look similar to the screenshot below:



​Let me know if I missed something and if you have further questions!
Kind regards,

Elita from support@eazybi.com

Elita- thx for your response. Much appreciated. It looks like I’m stuck on this phrase:

please define a new calculated measure replacing “Your Dimension name” with the dimension and/or property you have imported as your issue links.

Everything I tried doesnt seem to work. Is the dimension name “status category”? Something else? As mentioned, I’m really NEW to this :wink:

Hi @petemo94,

Thanks for following up with me and letting me know the formula doesn’t work for you.

What I meant by “Your dimension name” is the dimension name of the issue links. For the formula to work, I would first need to know if you have imported “is blocked by” issue links into your eazyBI report.
If you have not, the instructions here will help you with this.
The community post here is also very helpful when learning about issue links and how to import them into eazyBI. In the community post, at the end of the article, there are links to demo account reports; maybe it will be easier for you to follow a real example.
It is important that when you write your JavaScript code, one of the line says “dimension = true” so that your issue links get imported as dimension as well.
Depending on what name you define for your issue link custom field, this is the name you will also need to apply in the formula I gave you previously.
For example, if your Java Script code looks like below, then “Your dimension name” is “Linked Epics”, which is what you would use in the formula I gave you previously.

# Epics linked to issues
[jira.customfield_Linked_Epics]
name = "Linked Epics"
inward_link = "is blocked by"
issue_type = "Epic"
multiple_values = true
dimension = true

Hopefully, this is a little clearer now; if not - let me know!
Elita from support@eazybi.com

Thx Elita - so i did add the is blocked by dimension and I see it. However I think I dont have those advanced privileges to define NEW dimensions. I can’t seem to find that advanced menu to create these. Is this a role I need to add to my account? Like a Data Admin? or similar?