2 Replies Latest reply on Oct 19, 2012 10:41 AM by Ian White

    Drill down in a map

    Dave Worth

      I have a hierarchy country->state

       

      I want to be able to go from country view to states within US.

      Is this possible?

      In the designer it switches based on expanding / collapsing the Level of Detail - looking for a way to do interactively from published view.

        • 1. Re: Drill down in a map
          Nicholas Hermez

          I don't know of a way this can be done similar to clicking the "+" symbol in a table to drill-down.  I have always used a single-value (compact list) parameter that has values of, say Country, State, and ZIP, then a calculated field that changes the level of detail based on the parameter selection.  For example:

           

          CASE [parameter]

          WHEN 'Country' THEN [country]

          WHEN 'State' THEN [state]

          WHEN 'ZIP' THEN [zip]

          END

           

          If there is another way I would like to know!

           

          Nick

          • 2. Re: Drill down in a map
            Ian White

            Not sure if I understand the questions--is the need to drill down in a background map or just calculate the values that are nested in each level of geographic aggregation. I'm approaching this from a straight geo-perspective, so might be missing something. You may want to keep in mind that geography does not always roll up in a neat, hierarchical manner--some ZIPs cross municipal/state boundaries, and ZIPs themselves aren't as well-defined as we would like.

             

            If you want to associate various levels of geographic aggregation with your local data (ie, a given lng/lat is associated with a block group, tract, ZIP, sales territory, congressional district, county, custom region, state, etc...), that is something we can help with, but I can't speak to if/how that can be accomplished directly in Tableau.

             

            ian