Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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())
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
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.
Hi Prasantha,
Is it possible to share a samlpe QVF?
Thanks,
Sangram.