Hi Community,
I used Bar chart &
1)dimension-->branch_type
2)calculated dimension-->
if(match(branch_type,'DEPOT','FACTORY','PT','ST'),
(
if(Flag='RED','1',
if(Flag='YELLOW','2',
if(Flag='AMBER','3',
if(Flag='GREEN1','4'
))))))
----------------------------------------------------------------------------
RED--->param_value=<=-1 and param_value=>=-10
YELLOW--->param_value=<=-10.1 and param_value=>=-13.9
AMBER--->param_value=<=-14 and param_value=>=-17.9
GREEN--->param_value=<=-20
(Above are only names of color which are taken by creating Flag in script)
----------------------------------------------------------------------------
3) Expression
Count({$<param_name={'TEMP'},param_value={'<=-1'}>}param_value)/
Count(total <branch_type>{$<param_name={'TEMP'},param_value={'<=-1'}>}param_value)*100
it gives 400% which is wrong.
it should be 100% and there are diffrerent proportion for stacks for each branch_type