Display result of two sources in the same map

[clairebesson]

Hi everyone,

I have two dashboards that display results on a map. The first dashboard displays results for source1 and the second displays results for source2.
Here is the code for the first source:

<map>
        <search>
          <query>source="source1.csv"| geostats latfield=latitude longfield=longitude count</query>

        </search>
        <option name="mapping.data.maxClusters">100</option>
        <option name="mapping.drilldown">all</option>
        <option name="mapping.map.center">(52.43,-93.6)</option>
        <option name="mapping.map.zoom">4</option>
        <option name="mapping.markerLayer.markerMaxSize">50</option>
        <option name="mapping.markerLayer.markerMinSize">10</option>
        <option name="mapping.markerLayer.markerOpacity">0.8</option>
        <option name="mapping.tileLayer.maxZoom">7</option>
        <option name="mapping.tileLayer.minZoom">0</option>
        <option name="drilldown">all</option>
      </map>

The code for my second dashboard:

        <search>
          <query>source="source2l.csv"| geostats latfield=latitude longfield=longitude count</query>
          </search>

I want to display the results of my two searches on the same map with different color.
How to display results from different sources on the same map?

Thanks in advance for your help

[diogofgm · Accepted solution]

Search both sources and split by source:

source="source1.csv" OR source="source2l.csv"| geostats latfield=latitude longfield=longitude count by source

[clairebesson]

thank you very much.