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

    stack bar chart

    Satish Pawar

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

        • Re: stack bar chart
          Gysbert Wassenaar

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

            • Re: stack bar chart
              Satish Pawar

              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