Report on connected issues to objects

Questions & Answers
, ,
1

Dear community,

I have a customfield, where an asset obejct is linked:

image
image687×557 13.1 KB

Clicking on it and being redirected into Asset there is the section “connected tickets”:

image
image813×593 23.8 KB

I want to filter on objects, where all connected tickets are Resolution = Done. Is there any possibility?

Best regards,
Nicole

2

Hello @Nicole.Brueckner ,
You can analyze this information either:

  1. In the Asset data cube using measure “Jira issues created” and “Jira issues resolved.”
    Here you can create a simple formula that checks whether the measures are equal.
NonZero(Count(
  Filter(
    DescendantsSet([Object].CurrentHierarchyMember, [Object].CurrentHierarchy.Levels("Object")),
    ([Measures].[Issues created],
    [Time].CurrentHierarchy.DefaultMember)=
    ([Measures].[Issues resolved],
    [Time].CurrentHierarchy.DefaultMember)
  )
))
  1. Or in Jira issue cube using Asset customfield. Here is an example of my formula using “Business Service” customfield:
Nonzero(Count(
  Filter(
     DescendantsSet([Business Service].CurrentHierarchyMember, [Business Service].[Business Service]),
     ([Measures].[Issues created],
      [Time].CurrentHierarchy.DefaultMember)=
    ([Measures].[Issues resolved],
    [Time].CurrentHierarchy.DefaultMember)
  )
))

Kindly,
Gerda // support@eazybi.com