if else condition as Calculated Dimension

[sspawar88]

Hi ,

here i have stack bar chart for region.

each bar for each region is 100%.

Each color in stack bar chart have some range of param_value.

'Green' Color in Bar chart specifies temperature range <=-20 as per my if condition.

but it is also taking <=-18>=-19.9 range which is totally wrong. i don't want to show this range in bar chart.

i used calculated dimension are as following

if(param_name='TEMP',

if((param_value)<='-1' and (param_value)>= '-10', 'Red',

if((param_value)<= '-10.1' and (param_value)>='-13.9', 'Yellow',

if((param_value)<= '-14' and (param_value)>='-17.9', 'Amber',

if((param_value)<= '-20','Green')))))

( excluding values -18 to -19.9)

How can i Exclude Values in Between -18 to -19.9 in visualization of my stack bar chart?

[#2]

Give diffrent color for between -18 to -19.9

[MK_QSL]

if(param_name='TEMP',

if((param_value)<='-1' and (param_value)>= '-10', 'Red',

if((param_value)<= '-10.1' and (param_value)>='-13.9', 'Yellow',

if((param_value)<= '-14' and (param_value)>='-17.9', 'Amber',

if((param_value)<= '-20' and (param_value <= '-18' and param_value >='19.0') ,'Green')))))

[#4]

if(param_name='TEMP',

if((param_value)<='-1' and (param_value)>= '-10', 'Red',

if((param_value)<= '-10.1' and (param_value)>='-13.9', 'Yellow',

if((param_value)<= '-14' and (param_value)>='-17.9', 'Amber',

if((param_value)<= '-20' and (param_value <= '-18' and param_value >='19.0') ,'Green')))))

[sspawar88]

Hi Manish,

i don't want to include (param_value <= '-18' and param_value >='19.0') in my stack bar chart.

and as your comment i think you are doing completely opposite of this.