search

grafana / worldmap-panel

Worldmap panel plugin for Grafana 3.0 that can be overlaid with circles for data points.
MIT License
312 stars 199 forks source link

Showing a datapoint using an SQL #165

Closed syssec-laboratory closed 6 years ago

syssec-laboratory commented 6 years ago

Hi,

I am trying to use worldmap with postgresql as a data source. Can anyone let me know what are required db table schema to draw a data point? I tried to follow the instructions, but had no success yet.

I have simple queries without postgres. No luck so far. SELECT 10 as value, 55.378051 as latitude, -3.435973 as longitude SELECT 10 as metric, 55.378051 as latitude, -3.435973 as longitude (Format as Table)

If someone can point out what is wrong, I'll appreciate it.

syssec-laboratory commented 6 years ago

This example here helped me. https://community.grafana.com/t/worldmap-panel-with-mysql-database/1871/7