6 Replies Latest reply on Aug 5, 2013 3:01 AM by Jorge Villacampa

# Map: How to create "stepped colors maps" based on non-equal bin ranges

Hello,

I am trying to do a thematic map (Color filled map) where the color is based on transactions.  There are few countries (USA and France: eg 3M) with much larger number of transactions than the rest of the countries so when I ask Tableau to create 5 stepped color this is what I get (See picture).   I assume that Tableau creates internally equal bin ranges so it means that 5 countries are in the top 2 ranges and everyone else is in the bottom range(color).

Is there a way to create a more meaningful map: eg distribute colors better among countries (eg non equal bins).  In GIS softwares eg Mapinfo, you can do equal number within each range or other solution.

I could create my own Bin range and then create the map based on this bin range dimension.  However I would like this to be dynamic: eg based on percentile or similar idea.

Any suggestions?

Thank you

Jorge

• ###### 1. Re: Map: How to create "stepped colors maps" based on non-equal bin ranges

Jorge,

you could write your own logic to create non standard bins something like that

IF Transactions<500 THEN "TYPE A"

ELSEIF Transactions<750 THEN "TYPE B"

ELSEIF Transactions<3250 THEN "TYPE C"

ELSEIF Transactions<12500 THEN "TYPE D"

ELSEIF Transactions<16000 THEN "TYPE E"

ELSE "TYPE W"

END

Regards,

Cristian.

• ###### 2. Re: Map: How to create "stepped colors maps" based on non-equal bin ranges

Christian's solution offers a quick fix and that might work well for you (although, I think it should probably be SUM(Transactions) in each of the logic steps...

If you want to do it by percentile then this is quite possible using the formula

index() / size()

Add that to colour and make sure it is set to compute using Country, sorted by sum of Transactions (see screenshot, mine is sorted by Sum of Sales)

1 of 1 people found this helpful
• ###### 3. Re: Map: How to create "stepped colors maps" based on non-equal bin ranges

Many thanks Robin,

I will try your solution.  I think this will be answer I need.

Thanks again

Regards

Jorge

• ###### 4. Re: Map: How to create "stepped colors maps" based on non-equal bin ranges

Hello Cristian,

Thanks for your respond.  The problem with the solution your propose is that it is not dynamic.  So if I want to allow users to filter by department, subsidiary, or several months.... this will not work.

Thanks

regards

Jorge

• ###### 5. Re: Map: How to create "stepped colors maps" based on non-equal bin ranges

Jorge,

Take a look here, it's a thread worth to read Calculating and displaying deciles

Regards,

Cristian

• ###### 6. Re: Map: How to create "stepped colors maps" based on non-equal bin ranges

Many thanks Cristian,

I will try this to create the percentile for the map.

Thanks

Regards

Jorge