I have to show one average number for the following expression: (Score*Scope)/(Sum of Scope)
I have done this in a chart with a row for EACH DEFECT_ID but how can I translate it to a single variable for all applicable DEFECT_ID for a KPI?
Dimension: =if(match(CUR_STATUS,'Closed','Closed - Maintenance'),DEFECT_ID,
if(wildmatch(CUR_GOVERNANCE_PHASE,'5.1*'),DEFECT_ID,null()))
Score: aggr(if(count(TAGS_GOALS)>0,3,
if(not match(PRIMARY_DEFINE_BODY,'No Define Needed'),2,
if(match(PRIMARY_DEFINE_BODY,'No Define Needed'),1,
1))),DEFECT_ID)
Scope: if(isnull(EST_SCOPE_VALUE),1,EST_SCOPE_VALUE)
I am trying to set a variable called vWeight but it's not working:
=if(match(CUR_STATUS,'Closed','Closed - Maintenance') or if(wildmatch(CUR_GOVERNANCE_PHASE,'5.1*'),EST_SCOPE_VALUE*
(aggr(if(count(TAGS_GOALS)>0,3,
if(not match(PRIMARY_DEFINE_BODY,'No Define Needed'),2,
if(match(PRIMARY_DEFINE_BODY,'No Define Needed'),1,
1))),DEFECT_ID))/(sum(EST_SCOPE_VALUE)))