1 2 Previous Next 21 Replies Latest reply on Dec 30, 2016 4:49 PM by bhami sathi

    The sales data is coming from custom territory having group of counties in US. HOw do you create custom territory map?

    bhami sathi

      We are having lot of sales having around 40 million rows of data coming from various custom territories of group of counties. How do you represent profit in the map if we using customer territories with counties file as blended source.

      If we apply some filters on the primary source and the profit display is not reflecting in the map?

       

      can you please help me how to create custom geo codes with filled map instead of data blending?

        • 1. Re: The sales data is coming from custom territory having group of counties in US. HOw do you create custom territory map?
          lei.chen.0

          Hello Bhami,

           

          Could you please attach a workbook or some sample data?

           

           

          Regards

          • 2. Re: The sales data is coming from custom territory having group of counties in US. HOw do you create custom territory map?
            Jim Dehner

            Good morning

            Here is one way - (see the attached

             

            to create the "New Regions"  as a dimension I went to the Geographic dimension "State" right clicked and selected Create Group

            From there you get a state level drop down that can be aggregated into new groups - in the example I simple selected the first 10 alphabetically and called them my first 10, then the second 10 and finally all other

             

            The new region appears as a geo dimension that can be used like any other dimension -

             

            Does this help?

             

            Jim

            • 3. Re: The sales data is coming from custom territory having group of counties in US. HOw do you create custom territory map?
              bhami sathi

              Hi Lei Chen

               

               

              Please find the enclosed test file that demonstrates the issue

               

               

              I am not able to apply apply filters through gender and Age in the map.

               

               

              regards

               

              Bhami

              • 4. Re: The sales data is coming from custom territory having group of counties in US. HOw do you create custom territory map?
                bhami sathi

                Hellow Lei Chen

                 

                Thanks for your quick response. Please see the enclosed file having details about our requirement.

                I had prepared small data set. But we are having about 4 million records for 10 territories. I sent you the test file as i did not insert to this thread

                • 5. Re: The sales data is coming from custom territory having group of counties in US. HOw do you create custom territory map?
                  bhami sathi

                  Hi Jim

                   

                  In my case, the sales data is captured at customer regions having group of counties. I don't have data at county level.

                  How do we create map without using data blending. The data blending is having performance issue as i need to assign my sales data at county level dimensions

                   

                  pls help me.

                  • 6. Re: The sales data is coming from custom territory having group of counties in US. HOw do you create custom territory map?
                    Jim Dehner

                    Hi

                    I think this might do what you want - you do have to drive it off a drop down on the dashboard versus a map drill down - but I think it is getting the data panes right.

                     

                    Had to do a couple of things with the data - first - on the "Sheet 1 data source - related the Territory directly to the FIPS code to create a geo hierarchy

                     

                    Next - had to create a relationship (Data - Edit Relationship) the entry ties the Geo Territory on the Sheet 1 to the Custom Territory on the Sales Test (A string field)

                    Then make sure the link icon is red

                     

                    I have over done the detail and tool tips on the marks shelf so I could follow the data through the process

                     

                    Is this more like what you need?

                    Jim

                    • 7. Re: The sales data is coming from custom territory having group of counties in US. HOw do you create custom territory map?
                      bhami sathi

                      Hi Jim

                      Thanks for the details and new file. But there is slight difference with my requirement.

                      if i click on M or F bar then the respective change needs to be occured in the MAP. But this is not supporting it.

                       

                      can you please check?

                       

                      regards

                      Bhami

                      • 9. Re: The sales data is coming from custom territory having group of counties in US. HOw do you create custom territory map?
                        bhami sathi

                        Hi Jim

                        Thanks for your support

                         

                        Can you please give me some way to get this?

                        • 10. Re: The sales data is coming from custom territory having group of counties in US. HOw do you create custom territory map?
                          Jim Dehner

                          Good Morning -

                           

                          Sorry for the delay but for some reason I get an error message whenever I try to open your files - even the original - please resend the raw data and I will try to recreate the viz

                          • 11. Re: The sales data is coming from custom territory having group of counties in US. HOw do you create custom territory map?
                            bhami sathi

                            Hi Jim

                             

                             

                            I sorry for the delay. please find the enclosed file having this workbook.

                             

                             

                            thanks

                            • 12. Re: The sales data is coming from custom territory having group of counties in US. HOw do you create custom territory map?
                              Jim Dehner

                              I am having trouble with the data file - It will open once but then will not open again - even if I have saved it under another name

                              it gives a very long message that points at the query used with the fips codes

                               

                              the detailed message:   Tableau Data Engine Error: 48032: no such function (= integer string)

                               

                              The query script is:

                               

                              (restrict

                                (aggregate

                                  (project

                                    (project

                                      (table [TableauTemp].[map#txt])

                                      (

                                        ([$temp0_output]

                                          (case

                                            (isnull [FIPS Code])

                                            "Other"

                                            (case

                                              (= [FIPS Code] "48001")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48005")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48037")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48063")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48067")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48073")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48097")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48119")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48147")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48159")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48181")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48183")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48203")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48213")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48223")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48225")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48277")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48315")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48337")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48343")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48347")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48365")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48379")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48387")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48401")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48403")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48405")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48419")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48423")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48449")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48455")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48459")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48467")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48499")

                                              "48001, 48005, 48037 and 31 more"

                                              (= [FIPS Code] "48003")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48009")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48011")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48017")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48023")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48033")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48043")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48045")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48049")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48059")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48069")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48075")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48077")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48079")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48081")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48083")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48087")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48095")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48101")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48103")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48105")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48109")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48111")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48115")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48125")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48127")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48129")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48133")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48135")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48137")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48151")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48155")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48163")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48165")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48173")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48179")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48191")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48195")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48197")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48205")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48207")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48211")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48227")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48235")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48237")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48243")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48253")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48263")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48265")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48267")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48269")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48271")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48275")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48283")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48295")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48301")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48307")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48317")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48319")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48327")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48329")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48335")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48341")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48345")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48353")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48357")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48359")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48363")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48369")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48371")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48377")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48383")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48385")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48389")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48393")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48399")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48413")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48415")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48417")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48421")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48429")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48431")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48433")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48435")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48441")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48443")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48447")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48451")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48461")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48463")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48465")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48475")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48483")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48485")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48487")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48495")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48501")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48503")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48507")

                                              "48003, 48009, 48011 and 96 more"

                                              (= [FIPS Code] "48007")

                                              "48007, 48025, 48047 and 11 more"

                                              (= [FIPS Code] "48025")

                                              "48007, 48025, 48047 and 11 more"

                                              (= [FIPS Code] "48047")

                                              "48007, 48025, 48047 and 11 more"

                                              (= [FIPS Code] "48057")

                                              "48007, 48025, 48047 and 11 more"

                                              (= [FIPS Code] "48175")

                                              "48007, 48025, 48047 and 11 more"

                                              (= [FIPS Code] "48249")

                                              "48007, 48025, 48047 and 11 more"

                                              (= [FIPS Code] "48255")

                                              "48007, 48025, 48047 and 11 more"

                                              (= [FIPS Code] "48261")

                                              "48007, 48025, 48047 and 11 more"

                                              (= [FIPS Code] "48273")

                                              "48007, 48025, 48047 and 11 more"

                                              (= [FIPS Code] "48297")

                                              "48007, 48025, 48047 and 11 more"

                                              (= [FIPS Code] "48355")

                                              "48007, 48025, 48047 and 11 more"

                                              (= [FIPS Code] "48391")

                                              "48007, 48025, 48047 and 11 more"

                                              (= [FIPS Code] "48409")

                                              "48007, 48025, 48047 and 11 more"

                                              (= [FIPS Code] "48469")

                                              "48007, 48025, 48047 and 11 more"

                                              (= [FIPS Code] "48013")

                                              "48013, 48019, 48029 and 5 more"

                                              (= [FIPS Code] "48019")

                                              "48013, 48019, 48029 and 5 more"

                                              (= [FIPS Code] "48029")

                                              "48013, 48019, 48029 and 5 more"

                                              (= [FIPS Code] "48091")

                                              "48013, 48019, 48029 and 5 more"

                                              (= [FIPS Code] "48187")

                                              "48013, 48019, 48029 and 5 more"

                                              (= [FIPS Code] "48259")

                                              "48013, 48019, 48029 and 5 more"

                                              (= [FIPS Code] "48325")

                                              "48013, 48019, 48029 and 5 more"

                                              (= [FIPS Code] "48493")

                                              "48013, 48019, 48029 and 5 more"

                                              (= [FIPS Code] "48015")

                                              "48015, 48039, 48157 and 6 more"

                                              (= [FIPS Code] "48039")

                                              "48015, 48039, 48157 and 6 more"

                                              (= [FIPS Code] "48157")

                                              "48015, 48039, 48157 and 6 more"

                                              (= [FIPS Code] "48167")

                                              "48015, 48039, 48157 and 6 more"

                                              (= [FIPS Code] "48201")

                                              "48015, 48039, 48157 and 6 more"

                                              (= [FIPS Code] "48321")

                                              "48015, 48039, 48157 and 6 more"

                                              (= [FIPS Code] "48339")

                                              "48015, 48039, 48157 and 6 more"

                                              (= [FIPS Code] "48473")

                                              "48015, 48039, 48157 and 6 more"

                                              (= [FIPS Code] "48481")

                                              "48015, 48039, 48157 and 6 more"

                                              (= [FIPS Code] "48021")

                                              "48021, 48053, 48055 and 5 more"

                                              (= [FIPS Code] "48053")

                                              "48021, 48053, 48055 and 5 more"

                                              (= [FIPS Code] "48055")

                                              "48021, 48053, 48055 and 5 more"

                                              (= [FIPS Code] "48149")

                                              "48021, 48053, 48055 and 5 more"

                                              (= [FIPS Code] "48209")

                                              "48021, 48053, 48055 and 5 more"

                                              (= [FIPS Code] "48287")

                                              "48021, 48053, 48055 and 5 more"

                                              (= [FIPS Code] "48453")

                                              "48021, 48053, 48055 and 5 more"

                                              (= [FIPS Code] "48491")

                                              "48021, 48053, 48055 and 5 more"

                                              (= [FIPS Code] "48027")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48031")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48035")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48041")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48051")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48089")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48093")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48099")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48123")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48143")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48145")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48161")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48171")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48177")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48185")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48193")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48217")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48239")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48281")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48285")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48289")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48293")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48299")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48309")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48313")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48331")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48333")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48395")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48411")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48425")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48477")

                                              "48027, 48031, 48035 and 28 more"

                                              (= [FIPS Code] "48061")

                                              "48061, 48131, 48215 and 7 more"

                                              (= [FIPS Code] "48131")

                                              "48061, 48131, 48215 and 7 more"

                                              (= [FIPS Code] "48215")

                                              "48061, 48131, 48215 and 7 more"

                                              (= [FIPS Code] "48247")

                                              "48061, 48131, 48215 and 7 more"

                                              (= [FIPS Code] "48311")

                                              "48061, 48131, 48215 and 7 more"

                                              (= [FIPS Code] "48323")

                                              "48061, 48131, 48215 and 7 more"

                                              (= [FIPS Code] "48427")

                                              "48061, 48131, 48215 and 7 more"

                                              (= [FIPS Code] "48479")

                                              "48061, 48131, 48215 and 7 more"

                                              (= [FIPS Code] "48489")

                                              "48061, 48131, 48215 and 7 more"

                                              (= [FIPS Code] "48505")

                                              "48061, 48131, 48215 and 7 more"

                                              (= [FIPS Code] "48065")

                                              "48065, 48107, 48117 and 12 more"

                                              (= [FIPS Code] "48107")

                                              "48065, 48107, 48117 and 12 more"

                                              (= [FIPS Code] "48117")

                                              "48065, 48107, 48117 and 12 more"

                                              (= [FIPS Code] "48153")

                                              "48065, 48107, 48117 and 12 more"

                                              (= [FIPS Code] "48169")

                                              "48065, 48107, 48117 and 12 more"

                                              (= [FIPS Code] "48189")

                                              "48065, 48107, 48117 and 12 more"

                                              (= [FIPS Code] "48219")

                                              "48065, 48107, 48117 and 12 more"

                                              (= [FIPS Code] "48233")

                                              "48065, 48107, 48117 and 12 more"

                                              (= [FIPS Code] "48279")

                                              "48065, 48107, 48117 and 12 more"

                                              (= [FIPS Code] "48303")

                                              "48065, 48107, 48117 and 12 more"

                                              (= [FIPS Code] "48305")

                                              "48065, 48107, 48117 and 12 more"

                                              (= [FIPS Code] "48375")

                                              "48065, 48107, 48117 and 12 more"

                                              (= [FIPS Code] "48381")

                                              "48065, 48107, 48117 and 12 more"

                                              (= [FIPS Code] "48437")

                                              "48065, 48107, 48117 and 12 more"

                                              (= [FIPS Code] "48445")

                                              "48065, 48107, 48117 and 12 more"

                                              (= [FIPS Code] "48071")

                                              "48071, 48199, 48241 and 8 more"

                                              (= [FIPS Code] "48199")

                                              "48071, 48199, 48241 and 8 more"

                                              (= [FIPS Code] "48241")

                                              "48071, 48199, 48241 and 8 more"

                                              (= [FIPS Code] "48245")

                                              "48071, 48199, 48241 and 8 more"

                                              (= [FIPS Code] "48291")

                                              "48071, 48199, 48241 and 8 more"

                                              (= [FIPS Code] "48351")

                                              "48071, 48199, 48241 and 8 more"

                                              (= [FIPS Code] "48361")

                                              "48071, 48199, 48241 and 8 more"

                                              (= [FIPS Code] "48373")

                                              "48071, 48199, 48241 and 8 more"

                                              (= [FIPS Code] "48407")

                                              "48071, 48199, 48241 and 8 more"

                                              (= [FIPS Code] "48457")

                                              "48071, 48199, 48241 and 8 more"

                                              (= [FIPS Code] "48471")

                                              "48071, 48199, 48241 and 8 more"

                                              (= [FIPS Code] "48085")

                                              "48085, 48113, 48139 and 4 more"

                                              (= [FIPS Code] "48113")

                                              "48085, 48113, 48139 and 4 more"

                                              (= [FIPS Code] "48139")

                                              "48085, 48113, 48139 and 4 more"

                                              (= [FIPS Code] "48231")

                                              "48085, 48113, 48139 and 4 more"

                                              (= [FIPS Code] "48257")

                                              "48085, 48113, 48139 and 4 more"

                                              (= [FIPS Code] "48349")

                                              "48085, 48113, 48139 and 4 more"

                                              (= [FIPS Code] "48397")

                                              "48085, 48113, 48139 and 4 more"

                                              (= [FIPS Code] "48121")

                                              "48121, 48221, 48251 and 3 more"

                                              (= [FIPS Code] "48221")

                                              "48121, 48221, 48251 and 3 more"

                                              (= [FIPS Code] "48251")

                                              "48121, 48221, 48251 and 3 more"

                                              (= [FIPS Code] "48367")

                                              "48121, 48221, 48251 and 3 more"

                                              (= [FIPS Code] "48439")

                                              "48121, 48221, 48251 and 3 more"

                                              (= [FIPS Code] "48497")

                                              "48121, 48221, 48251 and 3 more"

                                              (= [FIPS Code] "48141")

                                              "48141 & 48229"

                                              (= [FIPS Code] "48229")

                                              "48141 & 48229" null)

                                            )

                                          )

                                        )

                                      )

                                    (

                                      ([FIPS Code (group)] [$temp0_output])

                                      )

                                    )

                                  (

                                    ([FIPS Code (group)] [FIPS Code (group)])

                                    ([FIPS Code] [FIPS Code])

                                    )

                                  ()

                                  )

                                ([FIPS Code (group)] [FIPS Code])

                                )

                              • 13. Re: The sales data is coming from custom territory having group of counties in US. HOw do you create custom territory map?
                                bhami sathi

                                Hi Jim

                                 

                                 

                                I had copied source files as enclosed. please open this workbook using enclosed source files.

                                 

                                 

                                thanks

                                • 14. Re: The sales data is coming from custom territory having group of counties in US. HOw do you create custom territory map?
                                  Jim Dehner

                                  Hi

                                   

                                  Finally I think I this will do what you want -

                                   

                                  The problem with getting the map to change when the age or gender charts were changed relates back to the blended data source -

                                  I could only get it to work by joining the sources on the SA name -

                                  Couple of other things - please check your map file - there are duplicate records in the text file - i just left them in there and used the Average sales versus the sum of sales - it does generate the results shown

                                   

                                  Had to do 2 other things to get the data to link -

                                  1 - Change the FIPS and the SA code  to GEO -  Go to Geographic role and scroll to the bottom of the drop down - from the CREATE - use from County

                                  2- on the Age tab you need to include a Gender filter and select Use All - do the reverse on the Gender Filter

                                   

                                  Then when you make the dashboard only use the Gender and the Age sheets as filters

                                   

                                  Hope this works for you

                                  Let me know

                                  Jim

                                  1 2 Previous Next