3 Replies Latest reply on Aug 6, 2018 5:59 PM by swaroop.gantela

# See the porcentage distribution by state in map

Hi everybody, how are you ?? I am starting to do maps in tableau and for example, I want to do the distribution of lead time by state like this:

But I want to see the distribution of porcentage in each state of the map. Now I see there:

I want to see the distribution of porcentage by colors and states. It's that possible?

• ###### 1. Re: See the porcentage distribution by state in map

Augustin,

I'm not sure that I fully understood,

but I think you are wanting to put AGG(Q de envi...) also on the Color shelf

because I don't think it will be clear what it means to add percentages.

If that is not helpful, please post a workbook with same fake sample data.

• ###### 2. Re: See the porcentage distribution by state in map

Hi swaroop! Thank you for your answer. I thing that you don't understood me.

In the map chart that I attached I saw one color by each state. I don't want this.

I want see the % of 'Q de envios' dimensioned by color in each state.

For example, I want to see in the map the state 'buenos aires' filled 56% in green color for lead time 3-5 days, 17% yellow color by 5-10 days, etc.

• ###### 3. Re: See the porcentage distribution by state in map

Augustin,

Please see if the below could give some ideas.

I created bins as a calculated field:

IF [Order to Ship]<1 THEN "< 1 day"

ELSEIF [Order to Ship]<2 THEN "1 day"

ELSEIF [Order to Ship]<3 THEN "2 days"

ELSEIF [Order to Ship]<4 THEN "3 days"

ELSEIF [Order to Ship]<5 THEN "4 days"

ELSEIF [Order to Ship]<5 THEN "5 days"

ELSE "> 6 day"

END

Then counted them per State:

{ FIXED [State],[Order to Ship Bins]:COUNT([Order to Ship Bins])}

Then got the total for the State:

{ FIXED [State]:COUNT([Order to Ship Bins])}

Which yielded the percentage to plot:

[Bin Count]/[State Total]