How to link dashboards from two data centers in one map visualization?

[angadbagga]

If I have two data centers, one in Germany and other in New Zealand, and I have created different dashboards for them. I want to link them to a map so that when I click on the country, that country's dashboards open. How can I do it? Can anyone help?

[DalJeanis]

Here's a trivial dashboard that can do the trick. Look around the <link> tag for what you have to localize for your installation. The actual format of the links will be something along the lines of [relative path]/[dashboard or form id]

<dashboard>
  <label>LinkFromMap </label>
  <row>
    <panel>
      <map>
        <search>
          <query>| makeresults | eval Country=mvappend("Germany","New Zealand") | mvexpand Country | eval count=2 | table Country count | geom geo_countries featureIdField=Country</query>
          <earliest>0</earliest>
          <latest></latest>
        </search>
         <option name="mapping.type">choropleth</option>
        <option name="mapping.tileLayer.tileOpacity">1</option>
        <option name="mapping.tileLayer.minZoom">0</option>
        <option name="mapping.tileLayer.maxZoom">7</option>
        <option name="mapping.showTiles">1</option>
        <option name="mapping.markerLayer.markerOpacity">0.8</option>
        <option name="mapping.markerLayer.markerMinSize">10</option>
        <option name="mapping.markerLayer.markerMaxSize">50</option>
        <option name="mapping.map.zoom">2</option>
        <option name="mapping.map.scrollZoom">0</option>
        <option name="mapping.map.panning">1</option>
        <option name="mapping.map.center">(0,0)</option>
        <option name="mapping.drilldown">all</option>
        <option name="mapping.data.maxClusters">100</option>
        <option name="mapping.choroplethLayer.showBorder">1</option>
        <option name="mapping.choroplethLayer.shapeOpacity">0.75</option>
        <option name="mapping.choroplethLayer.neutralPoint">0</option>
        <option name="mapping.choroplethLayer.minimumColor">0x2F25BA</option>
        <option name="mapping.choroplethLayer.maximumColor">0xDB5800</option>
        <option name="mapping.choroplethLayer.colorMode">auto</option>
        <option name="mapping.choroplethLayer.colorBins">2</option>

       <drilldown>
            <set token="SelectedCountry">$click.value$</set>
           <eval token="mylink">case($SelectedCountry$=="Germany","DElink",$SelectedCountry$=="New Zealand","NZlink",true(),"NoLink")</eval> 

  <!--  calculate the full links above in format  [relative path]/[dashboard or form id] and verify it looks right in the panel below the map.  Then remove the comment lines from around the link and /link tags to test.
         <link>
          $mylink$
          </link>
 -->

       </drilldown>

      </map>

    </panel>
  </row>

  <!--  this section is just so you can see the output, and should be commented or removed when the above is working-->
  <row>
    <panel>
 <title> $SelectedCountry$ $mylink$ </title>
    </panel>

  </row>
</dashboard>