2 Replies Latest reply: Jul 27, 2015 10:56 AM by Satish Pawar

# stack bar chart

is it any problem while if we are having multiple condition in stack for bar chart?

• ###### Re: stack bar chart

Maybe. It depends on your conditions. Can you explain in more detail what you're trying to do?

• ###### Re: stack bar chart

dimension=

1)branch_type

2)( i added following range of param_value as Calculated dimension)

if(match(branch_type,'FACTORY','PT','DEPOT','ST','Snowman'),

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

if(param_name='TEMP' and (param_value)<= '-10.1' and (param_value)>='-13.9', '2',

if(param_name='TEMP' and (param_value)<= '-14' and (param_value)>='-17.9', '3',

if(param_name='TEMP' and (param_value)<= '-18' and (param_value)>='-19.9', ' ',

if(param_name='TEMP' and (param_value)<= '-20', '4'))))),

if(match(branch_type,'RSV','RS Cold Room'),

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

if(param_name='TEMP' and (param_value)<= '-10.1' and (param_value)>='-13.9', '2',

if(param_name='TEMP' and (param_value)<= '-14' and (param_value)>='-17.9', '3',

if(param_name='TEMP' and (param_value)<= '-18', ' 4'))))))

Expression -

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

Count(total<branch_type>{<param_name={'TEMP'},param_value={'-1'}>}param_value)

It gives 400% & 500% Stack bar graph which is not correct.

it should give 100%

Thanks