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

    See the porcentage distribution by state in map

    Agustin Leira

      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:

       

      Captura de pantalla 2018-08-03 a la(s) 10.38.35.png

       

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

      Captura de pantalla 2018-08-03 a la(s) 10.40.15.png

       

      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
          swaroop.gantela

          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

          and change your Lead_Time_Days filter to "Single Value (list)"

          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
            Agustin Leira

            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
              swaroop.gantela

              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]

               

              Please see workbook v10.3 attached in the Forum Thread.