3 Replies Latest reply on Apr 21, 2018 6:47 AM by Sarah Battersby

    Multiple Points in Floor Map

    Zack Must

      Is there a way to plot the x/y coordinate if I have more that 50 Points on a floor map ? At the moment i am using the annotate and writing the x/y manually in the CSV file.. Can it be automated ?

        • 1. Re: Multiple Points in Floor Map
          Sarah Battersby

          Do you already have x/y coordinates in your CSV?  If so, you should be able to use them directly in Tableau and drop them on the image of your floor map.  Here is some information related to that process:

          Use Background Images in Your Views

           

          -Sarah

          Tableau Research

          • 2. Re: Multiple Points in Floor Map
            Zack Must

            Hi Sarah, I dont have x/y in my CSV file originally. Once i annotate in Tableau I type down the x and y value based on Tableau scale on the CSV file and I refresh the data sources ( Item Number is my primary key)

            • 3. Re: Multiple Points in Floor Map
              Sarah Battersby

              As far as I know, there isn't a way to directly export the annotation on your viz.   You *could* open your TWB in a text editor and write a script to pull out the individual values for each annotation point that you make. When you open the TWB somewhere in the text you'll see a section with annotation and each point will have some detail along these lines  that you could use the harvest the data...but unless you like scripting and pulling values out of XML files, I would suggest using a different tool to mark off the locations and get screen coordinates if you need to automate it.  I often do this sort of thing for geographic data in an open-source GIS package (QGIS), but for coordinates that are local (e.g,. set bottom corner to 0,0) there are probably simpler tools available to just add an image, set the bottom corner to 0,0 and then read off coordinates for the points that you add.

               

              Here is what the annotation text looks like in the TWB.... there are x and y coordinate values and the lat/lon values for each point that I marked off on a map.

               

              <point>

                            <visual-coordinate class='axis'>

                              <x-coord axis-value='-10600781.336321218'>

                                <node-reference>

                                  <axis>[federated.1chlctc18m0c99189myhe1ybnqox].[avg:Calculation_861032008025870339:qk]</axis>

                                </node-reference>

                              </x-coord>

                              <y-coord axis-value='5285567.9565651631'>

                                <node-reference>

                                  <axis>[federated.1chlctc18m0c99189myhe1ybnqox].[avg:Calculation_861032008025661442:qk]</axis>

                                </node-reference>

                              </y-coord>

                              <page-reference />

                              <projection name='EPSG:3857' u='-95.228438980263149' v='42.82628523806892' />

                            </visual-coordinate>

                          </point>