Issue in KPI coloring

[#1]

Hi,

I am trying to use expression to color the results, but it seems like its not working.

please advise if i am doing something wrong here (please refer the screen shot

I have an expression as below for one of my KPI

round(((sum({<fReportMetricKeyId={'1'},fMonthCD={$(=min(fMonthCD))}>}fCallAnsweredBeforeThreshold)

/

(sum({<fReportMetricKeyId={'1'}, fMonthCD={$(=min(fMonthCD))}>}fCallOffered)-sum({<fReportMetricKeyId={'1'}, fMonthCD=

{$(=Min(fMonthCD))}>}fFalseAttempts)))),0.01)

and for coloring i am using the below

if((round(((sum({<fReportMetricKeyId={'1'},fMonthCD={$(=min(fMonthCD))}>}fCallAnsweredBeforeThreshold)

/

(sum({<fReportMetricKeyId={'1'}, fMonthCD={$(=min(fMonthCD))}>}fCallOffered)-sum({<fReportMetricKeyId={'1'}, fMonthCD=

{$(=Min(fMonthCD))}>}fFalseAttempts)))),0.01))<.90,red(),green())

[kaushiknsolanki]

Hi,

Instead of expression you can you just try 0.90 as expression. and click the block above that to color that.

See images.

Regards,

Kaushik Solanki

[jagan]

HI,

Try  this

if((round(((sum({<fReportMetricKeyId={'1'},fMonthCD={$(=min(fMonthCD))}>}fCallAnsweredBeforeThreshold)

/

(sum({<fReportMetricKeyId={'1'}, fMonthCD={$(=min(fMonthCD))}>}fCallOffered)-sum({<fReportMetricKeyId={'1'}, fMonthCD=

{$(=Min(fMonthCD))}>}fFalseAttempts)))),0.01))< 0.90,red(),green())

Regards,

Jagan.

[reddy-s]

Hi Prasantha,

Is it possible to share a samlpe QVF?

Thanks,

Sangram.