Dynamic Colour Border in Indicator Label on straight table

[surtex]

Hey Community,

it is possible to create an dynamic colour border at Indicator label on a straight table like here:

If the value of each line (for each Cost_Element_Category2) in the second column is bigger than in the first column, the value should be red with attention symbol and if not, then the value should be green with success symbol. 

Thanks and best regards

Josh 

[MatheusC]

Hi, @surtex 
You can choose to use colors by expression and for icons you can use the option to customize the measurement.

See example; Here I used the default icons available in Windows. In Windows key + . ( point) . But you also have places like the favicon io site where you can find other icons 

In the color by expression, put your condition:"

If( Measure2 > Measure 1, LightRed(),LightBlue())


Regarts, Matheus

[brunobertels]

hi 

yes it's possible 

it should like somethink like this : 

You have a mesure for column 2 ( ex sum(salesY-1) )

then : 

for your mesure : 

if( column(2) < column(1) , sum(salesY-1)& '🔺' ,

sum(salesY-1)& '✔️' )

and in the color panel text expression :

if( column(2) < column(1) ,lightred(),lightgreen() )

you may have somethink like that : 

in the column ENTREE i use this formula to compare volume of ENTREE in a row with the above row 

🔺