How to create a interactive map with a table?

[danielhenrique]

Hello!

I am a begginer on grafana, my english is not good but let’s go! I need create a interactive map with a table, this tables is a item on zabbix, this item return a json and i am transform this json in a table on grafana.

I need click on item and filter other items and apply a zoom on map in the item clicked.

I need help please.

[infofcc3]

Create a Dashboard Variable

Dashboard Settings → Variables → Add variable
Type: Custom, Name: selected_prefix
Custom options: your PREFIXO values e.g. AAA,BBB,CCC
Enable Include All option → Custom all value: .*
Click Update → Save

Add Data Link to your existing Table panel

Edit Table panel → right side → Data links → Add link

URL: /d/YOUR-DASHBOARD-UID/dashboard-name?var-selected_prefix=${__data.fields.PREFIXO}

Replace YOUR-DASHBOARD-UID with the UID from your browser URL bar

Add Filter Transformation to Table panel

Edit Table panel → Transform tab → Add transformation
Select Filter data by values
Field: PREFIXO → Match: Matches regex → Value: ${selected_prefix:raw}

Create Geomap panel

Add panel → select Geomap visualization
Use same datasource as your table
Map layers → Latitude field: LATITUDE, Longitude field: LONGITUDE
Add same transformation to this panel too
In Map view settings → enable Fit to data

Click any table row → table filters + map zooms to that location

Select All in variable dropdown → everything resets

Do your Zabbix JSON fields include LATITUDE and LONGITUDE?

[danielhenrique]

@infofcc3

select Geomap visualization

Dear infofcc3
Thank you very much for you help.
Yes, my json include LATITUDE and LONGITUDE.
I using a datasource mixed with source panel on my table and transform and filter the data on latitude and longitude.

It was a success.

Thank you very much @infofcc3 !

[infofcc3]

Thanks @danielhenrique