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
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
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...