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?
