Set analysis in stack bar

[sspawar88]

When i put following expression in simple bar chart (dimension is branch_type) it gives correct result.

Count({$<param_name={'Temperature'},param_value={'<=-1'}>}param_value)/

Count(total{$<param_name={'Temperature'}>}param_value)*100

But i want stack chart for some temperature ranges suppose

-1 to -10

-10.1 to -13.9

-14 to -17.9

-18 and below

for this i used following calculated dimension

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

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

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

if(param_name='Temperature' and (param_value)<= '-18', 'Green'))

))

but when i add this calculated dimension in stack bar chart it showing value 400% which is incorrect.

whats wrong in my expression or input?

[krishna20]

Hi,

Can you please share some sample app such that it will be more useful to suggest you .

[Kushal_Chawda]

Please post sample