Count issues with linked "analyzes" Issue type Problem Record

[a.hauser]

Hi Community,

i try to count all created Spikes that are linked via issue links ‘analyzes’ to a problem record.
I got it to have all spike which have an analyzes outlink but struggle with the issue type problem record linked.

I use this measure:
NonZero(Sum(Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
not isEmpty([Issue].CurrentHierarchymember.Get(‘analyzes’))

AND
DateInPeriod(
[Measures].[Issue created date],
[Time].CurrentHierarchyMember
)),
[Measures].[Issues created]
))

Where do I have to add the Issue type filter?

[a.hauser]

has anybody an idea?

[gerda.grantina]

Hi @a.hauser ,
If you have “Issue” dimension in rows and want to see all the linked analyze problem records, then you can:

1. Use the issue_type parameter in the “analyze” issue link configuration. See detailed instructions here in this article. That will create a dimension that holds only the ‘problem’ issue types, and thus, the reporting will be straightforward:

Import issue links as dimension

Issue linking in Jira is a powerful option and is widely used. You can import issue links in eazyBI by using advanced settings for custom fields. In this article, I will try to explain how to set up and import issue links in eazyBI. There can be several use cases on what exactly users want to track in eazyBI with issue links. To demonstrate it, I will take one simple relation: stories with linked bugs. [eazyBI_Bugs] You can analyze this use case from two perspectives. One is to track Stori…

2. Create an MDX calculation that will filter all related ‘problem’ issue types, but keep in mind that this solution iterates through all dimension members and could cause performance issues. Please check the spelling of your dimension ‘analyzes’ and see other MDX examples in this training account report.

CASE WHEN
  [Issue].CurrentMember.Level.Name = "Issue"
  AND
  [analyzes].Currentmember is [analyzes].Defaultmember
THEN
  -- retrieve linked issue information from Issue property 'analyze'
  Nonzero(Count(
    Filter(
      [Issue].CurrentHierarchy.GetLinkedmembers('analyzes'),
      [Measures].[Issue type] = "Problem")
  ))
ELSE
 -- total calculation for any issue, data on linked issue level
  NonZero(Sum(
    Filter(
      DescendantsSet([analyzes].Currentmember, [analyzes].[analyzes]),
      [Issue Type].[Issue Type].getMemberNameByKey(
        [analyzes].CurrentHierarchyMember.get('Issue type ID')
      ) = "Problem"),
      -- counts how many times linked issues are reference with issues, this works as a filter as well
    [Measures].[Issues created]
 ))
END

Best,
Gerda // support@eazybi.com