Custom Territories in Tableau 10.0

During my Corporate Tableau Training in Gurgaon , i get questions many time regarding Custom Territories in Tableau .

Working With Custom Territories on a Map In Tableau 10.0

For Corporate training and Online Training contact at TJT@TECHNICALJOCKEY.COM

Tableau 10.0 gives you the feature of working on your own Custom Territory on Geographic Map.

There can be several use case for this and one of the simplest example can be that for Our Resource Planning, we have our custom Geographic Area created other than the one that actually exist and want to visualize that on the Map.

So for example, Our Business has different level of penetration in Different States of US and so we need to plan the resource accordingly. For e.g. “California, Oregon and Washington” is treated as a single entity and we call this as “4D” and “Florida, Michigan & Ohio” is treated as another entity and we call this as “6F” and want to visualize it on Map.Similarly, we can group together all other different states and create Custom Territories for our Analysis.

Custom Territories Can be confused with Geographical Groups, so we will do visualization both with Tableau 9.3 and Tableau 10.0 so that we can understand the advantage that Tableau 10.0 brings and how it was previously handled .

Based on the Use Case Defined above we group all the different states of US and name it as Custom Territory.  So as shown below we have a Group “Custom Territory” created as shown below:

Now if you drag the CustomTerritory on the map in Tableau 9.3 , the Geographical Map will not be able to identify it and you will see “10 Unknown” at the right bottom of the map.

 

If you go on to Edit locations , you will get the below screen . Tableau 9.3 is not able to identify "Custom Territory” and the Data within i.e. 1A , 2B, 3C …  Also since you can not attach Multiple matching location to Data , so you will not be able to attach 3 different states as Matching Location to 1A

 

 

If you do the same stuff in Tableau 10.0 i.e. drag and drop the Custom Territory on the map , Tableau 10.0 is able to identify the custom territory and able to show map as per the custom definition

 

 

To get a better view, you can drag and drop the Custom Territory to “Color” and “Label” and you can see Your Custom Geographic Location exactly the way you have defined.

[ akriti.lal@TechnicalJockey.com ]

 

Also if you go to Edit Locations for these in Tableau 10.0 , you will see matching correct US Locations , and the map showing the correct Custom  Territories.

 

There is another way in Tableau 9.3 that we have been creating Geographical Group.i.e. Drag And Drop State to the Map. There after Select “Washington, Oregaon and California” and click on Group Icon, and then select “Arizona , Idaho , Montano and 2 others” to group it . If we make it a filled map and also put on the Label we get the below visualization. The two grouped states are shown in color and the Others in “Other”.  

 

If you repeat the above step in “Tableau 10.0” you get similar results.( below screen shot , difference can be seen in the marks shelf for Colors and Text)

 

Now if you remove the original geographic location “State” from Marks shelf in Tableau 9.3 , you get the below i.e. The entire Geographic Location that we are considering in group is not shown in color now. The Group is sitting on the top of the base unit and Tableau is not able to Identify the remaining “Other” and is shown as “1 Unknown”.

 

 

Where is in Tableau 10.0 , if you remove the original geographic location “State” from Marks shelf , you will get the below visualization i.e. the custom Territory are distinctly shown

 

and if we want to rename these custom location as  “A” “B” “C” , go to edit groups , and rename it and you get the below

[ akriti.lal@TechnicalJockey.com ]

 

And if we want to Do Analysis for these 3 custom Territories say “Sales” or “Profit”, we can visualize it on map as usual.

 

 

So This is the Beauty of Tableau, and Keep Enjoying as Tableau continues improving the Life of Analyst by bringing in cool new features for your complex analysis. If you have any questions / concerns / feedback put down your comment below or feel free to mail me at

 


 

Write a comment

Comments

  • Mark Wu (Friday, September 09 16 12:05 am EDT)

    Awesome. This is exactly what I was looking for. Thank you for showing the difference in details between 93 and 10.

  • 4rx (Tuesday, April 11 17 03:19 am EDT)

    thank a lot for your site it aids a whole lot. http://bit.ly/2p7LTKb

Please enter the code
* Required fields

Subscribe to our mailing list

* indicates required

Looking for Corporate Training ? Reach out to us at Akriti.Lal@instrovate.com

Reach out to us if you are looking for Corporate Training to Build The Next Generation Analytical Workforce with an in-depth understanding of  Exploratory Data Analysis , Data Visualisation, Data Analytics , AI First , Machine Learning & Deep Learning Training & Consulting helping them to take Data Informed Decision at each stage of the business. 

We understand that At the present times , the Entire Industry is in a Tranformation stage with the Softwares  being rebuilt with Artificial Intelligence Capabilities .

We need SMART WORKFORCE for the SMART SOFTWARES to reap the maximum return . 

 

Whatsapp at +91-9953805788 or email at - akriti.lal@instrovate.com if you would like to know more . 

 

  • Corporate Tableau Training in Gurgaon
  • Corporate Data Analytics Training in Gurgaon
  • Corporate Microsoft Power BI Training in Gurgaon
  • Corporate Microstrategy Training in Gurgaon
  • Corporate Google Data Studio Training in Gurgaon
  • Corporate Python Training in Gurgaon
  • Corporate Advance Analytics in R Programming Training in Gurgaon
  • Corporate Machine Learning Training in Gurgaon
  • Corporate Deep Learning Training in Gurgaon
  • Corporate Data Visualization Training in Gurgaon

 

Address

Instrovate Technologies

Noida, Gurgaon

 

akriti.lal@instrovate.com 

Hit Your Refresh Button To Rise Higher
Print Print | Sitemap
All rights reserved @ Instrovate Technologies
GSTIN : 09AAECI6862K1Z1

Terms Of Services    Privacy Policy    Disclaimer     Refund Policy    


Call

E-mail