Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to build an image into this expression to show red dots for areas that achieved a certain target of <=50% and a green dot for those that achieved say 80%
sum({<GA_ActualTarget={'Actual'}>}GA_No)/sum({<GA_ActualTarget={'Target'}>}GA_No)
Thanx
Hi ,
Try the following:
In the expression tab add this expression
if(sum({<GA_ActualTarget={'Actual'}>}GA_No)/sum({<GA_ActualTarget={'Target'}>}GA_No)<=0.5,'qmem://<bundled>/BuiltIn/led_r.png',if(sum({<GA_ActualTarget={'Actual'}>}GA_No)/sum({<GA_ActualTarget={'Target'}>}GA_No)>=0.8,'qmem://<bundled>/BuiltIn/led_g.png'))
and in the Expression Tab for Display Options ,select Image.