Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,461,799
Community Members
 
Community Events
176
Community Groups

Measuring issues that have a linked issue in another project matching a certain condition

Hi,

I'd like to measure in/outflow on issues in project A that have a link to project B where the linked issue matches a certain condition. I assume I need to import both projects and import the issue links as well, but how to continue from there, do you have an example setup?

 

2 answers

Sorry, the question was related to EazyBI where I want to setup a measurement as described. How can  I use the 'linkedissuesOf' function in htere?

Hi @Cornelia Richter ,

The function 'linkedissuesOf'​ is a part of the ScriptRunner app that works within Jira.
​The eazyBI reports use a separate eazyBI data cube that holds data imported from Jira.

Depending on your requirements, several options might be possible to get the same effect as 'linkedissuesOf'.

​If you want a static filter built into the measure - you might address the linked issues by their issue keys.

​The below sample code fragment creates a set of issues from project A that have linked issues in status To Do and where linked issues are created within the selected time period.
​This set of issues from A could be used in further calculations.

Filter(
--generating a set of A project issues
  DescendantsSet([Issue].CurrentHierarchyMember, [Issue].[Issue]),
--actual filter
  Count(
 --Filtering the linked issues
    Filter(
 -- Generating set of linked issues
    [Issue].[Issue].GetMembersByKeys([Issue].[Issue].CurrentHierarchyMember.Get('All links')),
--conditions for linked issues - status To Do and created within current reporting period
    [Status].[Status].GetMemberNameByKey([Issue].[Issue].CurrentMember.Get('Status ID')) = "To Do"
     AND
    DateInPeriod([Issue].[Issue].CurrentMember.Get('Created at'), [Time].CurrentHierarchyMember)
   ) --end filter for linked issues
  ) --end count
  >0)


Alternatively, you might import the linked issue field dimension as a JavaScript calculated custom field. Then you might filter A issues based on the value of their linked B issue field through the page filter. 

​The best approach depends on your setup and requirements. If you get stuck - feel free to contact us directly.

​Regards,
​Oskars / support@eazyBI.com

0 votes

Hi @Cornelia Richter , What would the condition be? If understand the question correctly, you could use the 'linkedIssuesOf' function from ScriptRunner:

https://www.adaptavist.com/blog/top-10-most-commonly-used-jira-query-language-functions#linkedIssuesOf

Sorry,my question is related to eaziBI where I want to setup a measurement as described. How can I use the 'linkedIssuesOf' function in there?

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events