JIRA Structure - Check on issue link present

[Nikola Gaydarov]

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

[Stepan Kholodov _ALM Works_]

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