color in line chart

[soha1902]

Hi All,

I am using one line chart in my dashboard. In this chart Emp is a dimension and Sum(Sal) is expression.

Now my requirement is, if my line is increasing then it will show as green line and if it will decreasing then Red color.

please help.

[MayilVahanan]

Hi

Try like this

Background Color:

= if(PreviousSales - CurrentSales > 0, Green(), Red())

[soha1902]

Hi I tried to write

below expression under Background color

=if(Above(Sum(Sal) - Sum(Sal) > 0 , Red(),Green())

but its not working.

[stigchel · Accepted solution]

You can use the background color option of your expression (click on the plus sign in front of the expression) and use something like this

if(MyExp<Below(MyExp),lightgreen(),lightred())

Where MyExp is the label of your Sum(Sal) expression, if there are spaces in them put it between [] brackets.

[jsingh71]

use this expression:

if(Sal > Below(Sal) , Red(), Green()))

[Anonymous]

Hi,

  Use

(Sales-Below(Sales)<=0,green(),red()) 

in background exp, where  Sales is the name of the expression.