how to set color condition in bar chart

[#1]

i want to show condition in bar chart like if avergae is 100% dn it should be green otherwise if between 95 to 100 5 dn orange below that red.

[kaushiknsolanki]

Hi,

     Go to Expression,

     Cleck + next to the expression.

     Here Background Color

     Add expression as

     if(Column(1) > 0.95 and column(1) < 1, orange(),red());

Regards,

Kaushik Solanki

[#3]

its not working

[kaushiknsolanki]

Kindly post your Application.

Regards,

Kaushik Solanki

[#5]

i want to show something like dis

[kaushiknsolanki]

Have a look at the attached application.

Regards,

Kaushik Solanki

[sudeepkm]

is your expression like avg(SalesAmount) or something like that. Please share more detail on the application

[#8]

i have multiple excel and i have combined them and showed dm in a single graph and have used 8 expression in this  and my exp are like totaltime /breakdowntime to show the availablity of the system so i want if if system is available less then 98% then it should be orange less dn 95% dn red otherwise green

[sudeepkm]

you have 8 expression in a BAR chart and as per your dimension values those 8 will be repeated for each dimension values.

If your avg calculation is done by totaltime /breakdowntime

then as Kaushik mentioned you need to go to each expression background and

add the logic as

if( totaltime /breakdowntime>0 and totaltime /breakdowntime <.95,red(),

if( totaltime /breakdowntime >=.95 and totaltime /breakdowntime <.98,orange [use the RGB for Orange],green()))

[#10]

Hi kaushik,

       Where u wrote that if condition i didn't find any where in application can u please help me

      What is the   Cleck + next to the expression.?

Thanks