1 2 Previous Next 15 Replies Latest reply on Nov 13, 2018 3:01 PM by Mohamed Hersi

    What is the best Function/Statement for Color Coding Performance

    Mohamed Hersi

      I have data with a percentage column. I want to visualize this percentage column either as a Map or a Treemap and COLOR CODE it according to the predefined percentage ranges shown below. I have tried the following CASE statement but Tableau says it is invalid. Any help would be much appreciated.

       

      Predefined Color Codes:

      case [fieldname]

      WHEN >=30% THEN 'Red'

      WHEN <20% -30% THEN 'Orange'

      WHEN <10% - 20% THEN 'Light Orange'

      WHEN 5% - 10% THEN 'Light Green'

      WHEN 0% - 5% THEN 'Green'

      WHEN <0% THEN 'Purple'

      end

       

      Regards

      Mohamed

        1 2 Previous Next