Migrate to Geomap

[nick2000713]

Hi, are there any plans to migrate the world map panel to GeoMap? I'm having trouble getting it to work.

[sqelirus]

Hi, I did some tweaking and here is what I have done to make it work with Geomap.

1. Add a transformation: Choose "Reduce" and select calculation "Max"
2. In visualization option Data choose "Query: reduce-A-A-A-A..."
3. In visualization option Style > Size choose "Max"
4. In visualization option Style > Color choose "Max"

That's it.

[Regis-Loyaute]

Hi would it be possible for you to share the JSON of your panel ?

[sqelirus]

Sure, here it is.

Note that there is an issue with that tweak. When the Reduce transformation (step 1) is applied, it generates a Data named "Query: reduce-A-A-A-A-A..." that changes every time the request return a different quantity of countries and therefore needs to be manually selected in step 2. So if you can find out how to prevent that behavior and make it stable I would be very glad to know about how you made it work.

{
  "id": 563,
  "type": "geomap",
  "title": "IP - Src/Dst Blocked Geo",
  "description": "",
  "gridPos": {
    "x": 9,
    "y": 14,
    "h": 9,
    "w": 6
  },
  "fieldConfig": {
    "defaults": {
      "custom": {
        "hideFrom": {
          "tooltip": false,
          "viz": false,
          "legend": false
        }
      },
      "mappings": [],
      "thresholds": {
        "mode": "absolute",
        "steps": [
          {
            "color": "#37872D",
            "value": null
          },
          {
            "color": "#E0B400",
            "value": 10
          },
          {
            "color": "#FA6400",
            "value": 100
          },
          {
            "color": "#C4162A",
            "value": 1000
          }
        ]
      },
      "fieldMinMax": false
    },
    "overrides": []
  },
  "transformations": [
    {
      "id": "reduce",
      "options": {
        "labelsToFields": true,
        "reducers": [
          "max"
        ]
      }
    },
    {
      "id": "sortBy",
      "options": {
        "fields": {},
        "sort": [
          {
            "desc": true,
            "field": "Max"
          }
        ]
      }
    }
  ],
  "pluginVersion": "12.2.0-16979757807",
  "targets": [
    {
      "datasource": {
        "type": "marcusolsson-csv-datasource",
        "uid": "eevd15fgk4a2ob"
      },
      "refId": "A",
      "schema": [
        {
          "name": "",
          "type": "string"
        }
      ]
    }
  ],
  "maxDataPoints": 1,
  "datasource": {
    "uid": "eevd15fgk4a2ob",
    "type": "marcusolsson-csv-datasource"
  },
  "options": {
    "view": {
      "allLayers": true,
      "id": "zero",
      "lat": 0,
      "lon": 0,
      "noRepeat": false,
      "zoom": 1
    },
    "controls": {
      "showZoom": true,
      "mouseWheelZoom": false,
      "showAttribution": true,
      "showScale": false,
      "showMeasure": false,
      "showDebug": false
    },
    "tooltip": {
      "mode": "details"
    },
    "basemap": {
      "name": "Basemap",
      "type": "default"
    },
    "layers": [
      {
        "config": {
          "showLegend": true,
          "style": {
            "color": {
              "field": "Max",
              "fixed": "dark-green"
            },
            "opacity": 0.4,
            "rotation": {
              "fixed": 0,
              "max": 360,
              "min": -360,
              "mode": "mod"
            },
            "size": {
              "field": "Max",
              "fixed": 5,
              "max": 20,
              "min": 1
            },
            "symbol": {
              "fixed": "img/icons/marker/circle.svg",
              "mode": "fixed"
            },
            "symbolAlign": {
              "horizontal": "center",
              "vertical": "center"
            },
            "textConfig": {
              "fontSize": 12,
              "offsetX": 0,
              "offsetY": 0,
              "textAlign": "center",
              "textBaseline": "middle"
            }
          }
        },
        "filterData": {
          "id": "byRefId",
          "options": "reduce-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A"
        },
        "location": {
          "gazetteer": "public/gazetteer/countries.json",
          "lookup": "geoip_code",
          "mode": "lookup"
        },
        "name": "Layer 0",
        "tooltip": true,
        "type": "markers"
      }
    ]
  }
}