8 Replies Latest reply: May 17, 2014 3:32 AM by Dariusz Mielczarek RSS

    Color Code based on Inline Table utilizing two dimensions in that table

      I currently utilize color coding of cells in a straight table by using background expressions for each expression. There are two different sets of ranges per expression; I control which set by way of the variable vSLAindicator (for toggling).  I'm thinking this can be simplified by creating an Inline Table with two sets of ranges, but haven't quite figured out how bust to structure this Table and what functions I could used to look up the range vales given they would be based on two dimensions in that table, i.e. some sort of set indicator and another to designate which expression these ranges apply to.

       

      Background Expression associated to Expression 1

      if(vSLAindicator = 0,
      if(Sum(IF(RuntimeMins < 5,1,0))/count(Attempt)*100 > 29,RGB(3,197,255),
      if(Sum(IF(RuntimeMins < 5,1,0))/count(Attempt)*100 >= 25 and Sum(IF(RuntimeMins < 5,1,0))/count(Attempt)*100 <= 29,RGB(154,232,108),
      if(Sum(IF(RuntimeMins < 5,1,0))/count(Attempt)*100 >= 20 and Sum(IF(RuntimeMins < 5,1,0))/count(Attempt)*100 <= 25,Yellow(),
      if(Sum(IF(RuntimeMins < 5,1,0))/count(Attempt)*100 < 20,LightRed(),
      )))),
      if(Sum(IF(RuntimeMins < 5,1,0))/count(Attempt)*100 >= 70,RGB(154,232,108),
      if(Sum(IF(RuntimeMins < 5,1,0))/count(Attempt)*100 >= 50 and Sum(IF(RuntimeMins < 5,1,0))/count(Attempt)*100 <= 70,Yellow(),
      if(Sum(IF(RuntimeMins < 5,1,0))/count(Attempt)*100 < 50,LightRed(),
      ))))

       

      Background Expression associated to Expression 2

      if(vSLAindicator = 0,
      if(Sum(IF(RuntimeMins < 15,1,0))/count(Attempt)*100 > 73,RGB(3,197,255),
      if(Sum(IF(RuntimeMins < 15,1,0))/count(Attempt)*100 >= 50 and Sum(IF(RuntimeMins < 15,1,0))/count(Attempt)*100 <= 73,RGB(154,232,108),
      if(Sum(IF(RuntimeMins < 15,1,0))/count(Attempt)*100 >= 40 and Sum(IF(RuntimeMins < 15,1,0))/count(Attempt)*100 <= 50,Yellow(),
      if(Sum(IF(RuntimeMins < 15,1,0))/count(Attempt)*100 < 40,LightRed(),
      )))),
      if(Sum(IF(RuntimeMins < 15,1,0))/count(Attempt)*100 >= 85,RGB(154,232,108),
      if(Sum(IF(RuntimeMins < 15,1,0))/count(Attempt)*100 >= 70 and Sum(IF(RuntimeMins < 15,1,0))/count(Attempt)*100 <= 85,Yellow(),
      if(Sum(IF(RuntimeMins < 15,1,0))/count(Attempt)*100 < 70,LightRed(),
      ))))

       

      There are 2 more like these.