Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
🔺