Trying to build eazy BI issues to display the linked issues from ticket in dashboard

Questions & Answers
1

Dear community,

I am trying to build dashboard where I want o display the issues linked to the ticket.I am facing bugs in it and reports are not proper.

I am using the following MDX query
Sum(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
Not IsEmpty([Issue].CurrentMember.get(‘Links of issue’))),
CASE WHEN
[Measures].[Issues created]>0
THEN
Len([Issue].CurrentMember.get(‘Links of issue’))
- Len(Replace([Issue].CurrentMember.get(‘Links of issue’), ‘,’, ‘’))
+ 1
END
)
)
Please help me to resolve errors

2

Hello @Usharvi_Naik,

Thanks for posting your question!

To build a very simple Issue links report that shows the linked issue count (and, if needed, linked issues), you can follow the steps I described below. Make sure you have defined Issue links in the Import options first & have imported them in eazyBI: Import issue links

In this example, I will be looking at the Linked issues from the perspective of an outward link “Blocks”.

Here’s how I have defined it in the import options:

image.png
image.png1388×1068 63.1 KB

Steps to build a report once the Issue link has been imported:

  • Add Issue dimension to Rows, select “Issue” level member

  • Create a new calculated measure using the following formula (I named it “Blocks count”):

Case 
When
  [Issue].CurrentMember.Level.Name = "Issue"
  AND
  [Blocks].Currentmember is [Blocks].Defaultmember
Then
  Nonzero(Count(
    [Issue].CurrentHierarchy.GetLinkedmembers('Blocks')
  ))
Else
  NonZero(Sum(
    Descendants([Blocks].Currentmember, [Blocks].[Blocks]),
    [Measures].[Issues created]
 ))
End

  • Select the newly created measure “Blocks count” and property “Issue blocks” in Measures. Unselect the default measure “Issues created”

  • Enable “Hide empty” option

This report shows how many issues are blocked by “MNO-8” and “MNO-20” and the keys of the blocked issues:

image.png
image.png2264×1094 173 KB

You can build a similar report with the inward link (in my case it would be “is blocked by”) where you would see these issues from the “is blocked by” perspective:

image.png
image.png1570×756 77 KB

For a more detailed Issue Links report, I recommend reviewing our sample report (“Bugs” are the linked issues in this report): Stories with Bugs details - Issues - eazyBI Demo Training - eazyBI

I hope this helps!

Best,
Marita // support@eazybi.com