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:
+ 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!
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.
[Status].CurrentHierarchyMember.level.Name = "Category"
[Your Dimension name].[Your Dimension name].GetMembersByKeys(
[Measures].[Issue Your Dimension name]),
[Your Dimension name].CurrentHierarchyMember.Get('Status ID')).Parent.Name =
Count([Your Dimension name].[Your Dimension name].GetMembersByKeys([Measures].[Issue Your Dimension name])
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!
Elita from email@example.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
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.
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
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 firstname.lastname@example.org
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?