grafanaworldmap.md

Use the following query - World Map:

SELECT
  UNIX_TIMESTAMP(`timestamp`) as time_sec,
  COUNT(*) as value,
  dst_country_code as metric
FROM IDS
WHERE $__timeFilter(`timestamp`) AND dst_country_code != "NULL"
ORDER BY `timestamp` ASC

Choose countries

Histogram by Port

SELECT UNIX_TIMESTAMP(ts) as time_sec, COUNT(*) as value, src_port as metric FROM IDS WHERE $__timeFilter(ts) GROUP BY src_port ORDER BY ts LIMIT 10

Format as timeseries and Mode Timeseries