I have successfully created a linked property as follows
#Test Cases blocked by Defect - Defect view
[jira.customfield_blockedTestCases]
name = “Blocked Test Cases”
outward_link = “blocks” #direction from Defect
issue_type = “Test”
dimension = true
Above worked great if I have listed all defects and shows all the test cases that are blocked by each defect (separated by comma).
What i am trying to achieve is to list the same test cases by Assignee. I would like to list all the assignee and add a column that shows all linked test cases by assignee. Is there a way to achieve this?
Screenshot below shows list of assignees with defect priority counts. Would like to add a column that lists all linked issues with linked type “blocks” (# of test cases blocked by defects assigned to the assignee) .
Another question - Can I combine dimension counts? For eg, how can i get a count of Issues that have Priority = Critical AND Severity = (Critical OR High).
You would like to access the Blocked Test cases dimension to get this counter.
NonZero(SUM(
Filter(
Descendants([Blocked Test Cases].Currentmember, [Blocked Test Cases].[Blocked Test Cases]),
-- filter out Blocked Test Cases related to issues in report
([Measures].[Issues created],
[Assignee].CurrentHierarchy.Defaultmember,
[Time].CurrentHierarchy.Defaultmember) > 0),
-- search for Blocked Test Cases in Issue dimension, use in a tuple with measure, assignee and time, ignore anything else with DefaultContext
CASE WHEN
DefaultContext((
[Measures].[Issues created],
[Issue].[Issue].GetMemberByKey([Bugs].Currentmember.Key),
[Assignee].CurrentMember, -- filter linked issues by assignee
[Time].CurrentHierarchyMember, -- filter linked issues by time
[Blocked Test Cases].DefaultMember
)) > 0
THEN 1 END
))
The formula might work slow in accounts with a lot of issues. You can consider an alternative by importing a new field with calculated javascript code counting issues with a particular link:
In this community post there is an example at the end of the thread:
