Create single metric from complex expression

cbaqir — Sat, 16 Nov 2024 01:10:49 GMT

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

topic Create single metric from complex expression in QlikView

Create single metric from complex expression