Created
June 5, 2018 18:39
-
-
Save skord/73971b40803cf8b5de1a83a5915d0c08 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "__inputs": [ | |
| { | |
| "name": "DS_MARIADB", | |
| "label": "mariadb", | |
| "description": "", | |
| "type": "datasource", | |
| "pluginId": "mysql", | |
| "pluginName": "MySQL" | |
| } | |
| ], | |
| "__requires": [ | |
| { | |
| "type": "grafana", | |
| "id": "grafana", | |
| "name": "Grafana", | |
| "version": "5.1.3" | |
| }, | |
| { | |
| "type": "panel", | |
| "id": "grafana-worldmap-panel", | |
| "name": "Worldmap Panel", | |
| "version": "0.0.21" | |
| }, | |
| { | |
| "type": "datasource", | |
| "id": "mysql", | |
| "name": "MySQL", | |
| "version": "5.0.0" | |
| } | |
| ], | |
| "annotations": { | |
| "list": [ | |
| { | |
| "builtIn": 1, | |
| "datasource": "-- Grafana --", | |
| "enable": true, | |
| "hide": true, | |
| "iconColor": "rgba(0, 211, 255, 1)", | |
| "name": "Annotations & Alerts", | |
| "type": "dashboard" | |
| } | |
| ] | |
| }, | |
| "editable": true, | |
| "gnetId": null, | |
| "graphTooltip": 0, | |
| "id": null, | |
| "iteration": 1528217284550, | |
| "links": [], | |
| "panels": [ | |
| { | |
| "circleMaxSize": "2", | |
| "circleMinSize": 2, | |
| "colors": [ | |
| "rgba(245, 54, 54, 0.9)", | |
| "#3f6833", | |
| "rgba(50, 172, 45, 0.97)" | |
| ], | |
| "datasource": "${DS_MARIADB}", | |
| "decimals": 0, | |
| "esGeoPoint": "Geohash", | |
| "esLocationName": "Country", | |
| "esMetric": "Count", | |
| "gridPos": { | |
| "h": 18, | |
| "w": 24, | |
| "x": 0, | |
| "y": 0 | |
| }, | |
| "hideEmpty": false, | |
| "hideZero": false, | |
| "id": 2, | |
| "initialZoom": 1, | |
| "links": [], | |
| "locationData": "geohash", | |
| "mapCenter": "(0°, 0°)", | |
| "mapCenterLatitude": 0, | |
| "mapCenterLongitude": 0, | |
| "maxDataPoints": 1, | |
| "showLegend": true, | |
| "stickyLabels": true, | |
| "targets": [ | |
| { | |
| "alias": "", | |
| "format": "table", | |
| "hide": false, | |
| "rawSql": "SELECT\nalpha3 as Country,\ngeohash as Geohash,\nicao as Icao,\ncount(Geohash) as Count\n\nFROM flights for SYSTEM_TIME\nas of timestamp (now() - interval $our_interval minute)\nwhere alpha3 = '$alpha3'\ngroup by Geohash\n", | |
| "refId": "A" | |
| } | |
| ], | |
| "thresholds": "0,10", | |
| "title": "Panel Title", | |
| "type": "grafana-worldmap-panel", | |
| "unitPlural": "", | |
| "unitSingle": "", | |
| "valueName": "total" | |
| }, | |
| { | |
| "circleMaxSize": "2", | |
| "circleMinSize": 2, | |
| "colors": [ | |
| "rgba(245, 54, 54, 0.9)", | |
| "#3f6833", | |
| "rgba(50, 172, 45, 0.97)" | |
| ], | |
| "datasource": "${DS_MARIADB}", | |
| "decimals": 0, | |
| "esGeoPoint": "Geohash", | |
| "esLocationName": "Country", | |
| "esMetric": "Count", | |
| "gridPos": { | |
| "h": 18, | |
| "w": 24, | |
| "x": 0, | |
| "y": 18 | |
| }, | |
| "hideEmpty": false, | |
| "hideZero": false, | |
| "id": 3, | |
| "initialZoom": 1, | |
| "links": [], | |
| "locationData": "countries_3letter", | |
| "mapCenter": "(0°, 0°)", | |
| "mapCenterLatitude": 0, | |
| "mapCenterLongitude": 0, | |
| "maxDataPoints": 1, | |
| "showLegend": true, | |
| "stickyLabels": true, | |
| "targets": [ | |
| { | |
| "alias": "", | |
| "format": "table", | |
| "hide": false, | |
| "rawSql": "SELECT\nalpha3 as Country,\ncount(alpha3) as value,\nalpha3 as metric\n\nFROM flights for SYSTEM_TIME\nas of timestamp (now() - interval $our_interval minute)\nwhere alpha3 = '$alpha3'\ngroup by metric\n", | |
| "refId": "A" | |
| } | |
| ], | |
| "thresholds": "0,10", | |
| "title": "Panel Title", | |
| "type": "grafana-worldmap-panel", | |
| "unitPlural": "", | |
| "unitSingle": "", | |
| "valueName": "avg" | |
| } | |
| ], | |
| "schemaVersion": 16, | |
| "style": "dark", | |
| "tags": [], | |
| "templating": { | |
| "list": [ | |
| { | |
| "auto": false, | |
| "auto_count": 30, | |
| "auto_min": "10s", | |
| "current": { | |
| "text": "1", | |
| "value": "1" | |
| }, | |
| "hide": 0, | |
| "label": "Minutes Ago", | |
| "name": "our_interval", | |
| "options": [ | |
| { | |
| "selected": true, | |
| "text": "1", | |
| "value": "1" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "5", | |
| "value": "5" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "10", | |
| "value": "10" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "15", | |
| "value": "15" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "30", | |
| "value": "30" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "60", | |
| "value": "60" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "90", | |
| "value": "90" | |
| } | |
| ], | |
| "query": "1,5,10,15,30,60,90", | |
| "refresh": 2, | |
| "type": "interval" | |
| }, | |
| { | |
| "allValue": null, | |
| "current": {}, | |
| "datasource": "${DS_MARIADB}", | |
| "hide": 0, | |
| "includeAll": false, | |
| "label": "Country Code", | |
| "multi": false, | |
| "name": "alpha3", | |
| "options": [], | |
| "query": "select distinct(alpha3) from flights order by alpha3", | |
| "refresh": 1, | |
| "regex": "", | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| } | |
| ] | |
| }, | |
| "time": { | |
| "from": "now/d", | |
| "to": "now/d" | |
| }, | |
| "timepicker": { | |
| "refresh_intervals": [ | |
| "5s", | |
| "10s", | |
| "30s", | |
| "1m", | |
| "5m", | |
| "15m", | |
| "30m", | |
| "1h", | |
| "2h", | |
| "1d" | |
| ], | |
| "time_options": [ | |
| "5m", | |
| "15m", | |
| "1h", | |
| "6h", | |
| "12h", | |
| "24h", | |
| "2d", | |
| "7d", | |
| "30d" | |
| ] | |
| }, | |
| "timezone": "", | |
| "title": "Flights", | |
| "uid": "_VlbWFIik", | |
| "version": 11 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment