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,361,805
Community Members
 
Community Events
168
Community Groups

JIRA Structure - Check on issue link present

Hi,

we have a logical model Capability -> EPIC -> Capacity Demand.

I want to display in the Structure:

1) When there is a Capacity Demand related to the Epic (Relates type of link) - display 100%

2) When there is no Capacity Demand related to the Epic - display 0%

3) On the Capability level see the overall result as percentage, e.g. we have 10 Epics related to the Capability, from them 7 have Capacity Demand related, 3 dont have - display 70% on Capability level

Cheers,

Nikola

1 answer

2 votes

Hello Nikola,

Since this matter was already resolved by communicating with you via our support channel, I just wanted to post the formula that answers the question here in case anybody else will find it useful:

if type="Epic" and issueLinks.FILTER($.type ='Relates').MAP(IF $.source = this: $.destination ELSE $.source).FILTER($.issuetype="Capacity Demand"): 1
ELSE: 0

Best regards,
Stepan Kholodov
ALM Works

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Apps for Confluence you won't want to miss: RSVP for September's Appy Hours

Calling all collaborators and Confluence users! Our Appy Hours event on September 29th features 4 presenters demoing functionality to superpower Confluence. Don't miss learning about these apps i...

125 views 0 9
Read article

Atlassian Community Events