Skip to main content

Posts

Showing posts with the label color scale varying ranges

Custom Color Scale for Ranges of Data

Create a color scale that separates data into varying ranges. Using the sample Superstore data to compare varying ranges of Sales.  1. Select  Analysis  >  Create Calculated Field 2. Name the field. In this example, it is named Five Colors. Enter a calculation similar to the following, then click OK: IF SUM(Sales)<20000 THEN 'GRAY' ELSEIF SUM(Sales)>=20000 AND SUM(Sales)<90000 THEN 'LIGHT RED' ELSEIF SUM(Sales)>=100000 AND SUM(Sales)<150000 THEN 'DARK RED' ELSEIF SUM(Sales)>=150000 AND SUM(Sales)<300000 THEN 'LIGHT BLUE' ELSE 'DARK BLUE' END 3. Place the calculated field on the  Color  shelf 4. Click the Color legend drop-down arrow, and select  Edit Colors  to choose your desired colors. See the steps in the video below from Tableau site: