4 Replies Latest reply on Nov 7, 2017 4:36 PM by Christopher Jack

    Pie Charts On Maps

    Bianca Reddick

      I am trying to turn specific regions into pie charts on a map using the building name for the angle and the amount of records to size the angle. These are the regions I have specified, but I need to be able to add the buildings in to break out the pie chart (drawn in blue) and the amount of records at each building.Tableau.PNG

        • 1. Re: Pie Charts On Maps
          Carl Slifer

          Hi Bianca,

           

          Your post states that you want both building name and the number of records as the Angle.

          Right now it appear that your marks type is a circle or a pie chart with nothing on Angle.

           

          Try this, drag your 'building name' field onto detail.

          Now click on colour on your marks card and select border, then select the shade of blue you want. 

          Now drag 'number of records' to your angle shelf.

           

          By doing the above you will maintain your pie charts being coloured not based on each slice, but rather the entire pie chart being coloured the same and each pie chart being coloured based on the city. You will have a border within each shape that shows the breakdown by your building name.

           

          Cheers!

          Carl Slifer

          InterWorks

          • 2. Re: Pie Charts On Maps
            Bianca Reddick

            Hi Carl,

             

            Thank you for your response. The issue I run into is that it breaks out multiple pie charts based on the lat and long of the building. I would like to see one pie chart for region that I created by grouping zip codes. Please let me know if you have any suggestions.

             

            Thank you,

             

            Bianca Reddick

            • 3. Re: Pie Charts On Maps
              Carl Slifer

              Without seeing your data I'm not much help here. It sounds like you've

              built geocoding around  building name and when dragging it to your details

              shelf you automatically get lat and long on your rows and columns shelves?

              Try either removing these from the R and C shelf or just making a duplicate

              of building name and removing the geolocation from the field.

              Send a mocked up same and I or someone else can look at it.

               

              On 2 June 2016 at 13:40, Bianca Reddick <tableaucommunity@tableau.com>

              • 4. Re: Pie Charts On Maps
                Christopher Jack

                 

                Hi Bianca I think this is what you're looking for.  The table structure is below.

                 

                      

                RegionBuildingAddressCityStateLatitudeLongitude
                SouthA1MiamiFL25.758958-80.197607
                SouthA2MiamiFL25.758958-80.197607
                SouthA3MiamiFL25.758958-80.197607
                SouthA4MiamiFL25.758958-80.197607
                SouthB5MiamiFL25.758958-80.197607
                SouthC6MiamiFL25.758958-80.197607
                SouthC7MiamiFL25.758958-80.197607
                NorthD8OrandoFL28.536248-81.394357
                NorthD9OrandoFL28.536248-81.394357
                NorthE10OrandoFL28.536248-81.394357
                NorthE11OrandoFL28.536248-81.394357
                NorthF12OrandoFL28.536248-81.394357
                WestG13TampaFL27.951962-82.473515
                WestG14TampaFL27.951962-82.473515
                WestH15TampaFL27.951962-82.473515
                WestI16TampaFL27.951962-82.473515