0 Replies Latest reply: Jul 24, 2015 6:54 AM by Satish Pawar RSS

    Issue in stack bar

    Satish Pawar

      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.

       

       

      11111.PNG

       

      it should be 100% and there are diffrerent proportion for stacks for each branch_type