2 Replies Latest reply on May 3, 2012 9:16 AM by johnfrederickson

    how can I high light data that meets certain criteria

      I have a data table.  If the values in the table are <90, I want to high-light them red.  If they are >103 I want to high light them in green.

        • 1. Re: how can I high light data that meets certain criteria
          Tracy Rodgers

          Hi John,

           

          This can be done by first creating a calculated field similar to the following:

           

          if sum([Value])<90 then 'red'

          elseif sum([Value])>103 then 'green'

          else 'yellow' end

           

          Change the mark type on your view to Bar. Then, place this calculation on the color shelf and if desired the sum(Value) on the label shelf. Then, place Number of Records on the size shelf. Click in the upper right of the size legend and select Edit Sizes... Then, drag the slider to the far right so that all the bars are the same length. Then, edit the colors in your color legend.

           

          Hope this helps!

           

          -Tracy

          • 2. Re: how can I high light data that meets certain criteria

            Thanks, Tracy.  I used your suggestion and it works fine for a single field (column).  However, all columns then follow that condition and are colorized according to the same parameters.  I need to colorize with each column of data having separate parameters.  Any ideas?

             

            John

            1 of 1 people found this helpful