Ok thanks using, choropleth map will I be able to set one color for for a marker that contain two fields, for example the color of field2 depends on the color of field1, if the field1 value is "ok "the two fields will be colored green, re-posting the code I used.
| eval status = if (isnotnull (Type) ,"KO","OK")
|eval status = "City: ".sitename .",". status
|makemv status delim=","
| table sitename ID status Latitudine Longitudine
| geostats latfield=Latitudine longfield=Longitudine count by status</query>
<earliest>$field1.earliest$</earliest>
<latest>$field1.latest$</latest>
<sampleRatio>1</sampleRatio>
<refresh>10m</refresh>
<refreshType>delay</refreshType>
</search>
<option name="drilldown">none</option>
<option name="height">423</option>
<option name="mapping.choroplethLayer.colorBins">3</option>
<option name="mapping.choroplethLayer.colorMode">auto</option>
<option name="mapping.choroplethLayer.maximumColor">0xe60026</option>
<option name="mapping.choroplethLayer.minimumColor">0x6dc066</option>
<option name="mapping.choroplethLayer.neutralPoint">0</option>
<option name="mapping.choroplethLayer.shapeOpacity">0.75</option>
<option name="mapping.choroplethLayer.showBorder">1</option>
<option name="mapping.data.maxClusters">999</option>
<option name="mapping.fieldColors">{OK:0x6dc066,KO:0xe60026}</option>
... View more