Gauge in table

guillaume_gorli — Tue, 17 Apr 2018 20:54:33 GMT

Hi All,

I have three variables in my model :

Date

Estimate

Actual

I need to compare Estimate vs Actual and show the output through a gauge in a table chart :

If Estmate / Actual is less than 90 % than the light should be red

If Estimate / Actual is between 90 % and 110 % the light should be green

If Estimate / Actual is greater than 110 % the light should be red.

I have been able to get the results through a three color gauge although i would like to have it through a two color gauge :

What i got is :

What i am looking for is :

Thanks for the one who want to help

Attached is qvw and excel test database

Guillaume

Re: Gauge in table

guillaume_gorli — Fri, 20 Apr 2018 08:38:45 GMT

Hi everyone,

Is my request not possible to full fill ?

Guillaume

pooja_prabhu_n — Fri, 20 Apr 2018 13:05:02 GMT

Hi,

Use as Expression foe KPI

=if(KeepChar([Estimate vs Actual],0123456789)>=90 and KeepChar([Estimate vs Actual],0123456789)<=110,1,0)

PFA