# Correlate prometheus data with a geomap csv

**URL:** <https://community.grafana.com/t/correlate-prometheus-data-with-a-geomap-csv/152041>\
**Category:** Grafana\
**Tags:** geomap-panel\
**Created:** [June 5, 2025, 4:44pm UTC](https://community.grafana.com/t/correlate-prometheus-data-with-a-geomap-csv/152041 "2025-06-05T16:44:31Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![miguelalfarozgz](https://avatars.discourse-cdn.com/v4/letter/m/4af34b/32.png) [@miguelalfarozgz](https://community.grafana.com/u/miguelalfarozgz)\
**Post date:** [June 5, 2025, 4:44pm UTC](https://community.grafana.com/t/correlate-prometheus-data-with-a-geomap-csv/152041/1 "2025-06-05T16:44:31Z")

</div>

We have a prom monit which we check if a network device is down or not.  
This is the result that spits out (changing instance name due to confidentiality):

`probe_success{asset_id="685", asset_name="switch4", environment="N1", hierarchy="2", instance="switch4", job="ping", location="location4", project="project1"} 1`

I know where this switch4 is located on a geomap, so i added the query that returned this and the csv on the same pannel:

query:  
probe\_success{instance=~“._switch._”} and probe\_success{job!=“blackbox\_linux”}

csv:  
asset\_id,asset\_name,lat,lon,value  
“685”,"switch4 ",40.768271, -73.422925

Im not quite sure though how to make this work, the asset\_id matches both the csv and the promql, so that would be where the data had to match, im just trying to add both the to the map, not event trying to do anything yet, but i would like to know if it is possible before diving in

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [June 5, 2025, 5:13pm UTC](https://community.grafana.com/t/correlate-prometheus-data-with-a-geomap-csv/152041/2 "2025-06-05T17:13:32Z")

</div>

not sure how to extract asset\_id from

`probe_success{asset_id="685", asset_name="switch4", environment="N1", hierarchy="2", instance="switch4", job="ping", location="location4", project="project1"} 1`

Can you do this transformation?

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/6/d/6d6ca591507e699db7fddc64adfe1ea5718e55c1.png)

---

<div class="post-metadata">

**Author:** ![miguelalfarozgz](https://avatars.discourse-cdn.com/v4/letter/m/4af34b/32.png) [@miguelalfarozgz](https://community.grafana.com/u/miguelalfarozgz)\
**Post date:** [June 5, 2025, 5:24pm UTC](https://community.grafana.com/t/correlate-prometheus-data-with-a-geomap-csv/152041/3 "2025-06-05T17:24:12Z")

</div>

I can extract something called “apps id” which I’m unsure if it is what you mean:

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/4/b/4bc7566a431422d14f8e9c70e2fc4030dc3374e7.png)

The other options are apps asset\_name, apps lat… And down below shows the fields but to the right says “(base field name)”

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/c/b/cb6d85e305cdb14d201da29caadcd86826be5be8.png)

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [June 5, 2025, 6:06pm UTC](https://community.grafana.com/t/correlate-prometheus-data-with-a-geomap-csv/152041/4 "2025-06-05T18:06:15Z")

</div>

well the correlation key is asset\_id correct?

---

<div class="post-metadata">

**Author:** ![miguelalfarozgz](https://avatars.discourse-cdn.com/v4/letter/m/4af34b/32.png) [@miguelalfarozgz](https://community.grafana.com/u/miguelalfarozgz)\
**Post date:** [June 5, 2025, 6:22pm UTC](https://community.grafana.com/t/correlate-prometheus-data-with-a-geomap-csv/152041/5 "2025-06-05T18:22:31Z")

</div>

Yes, but that one does not appear on the field option, that’s what’s bugging me, even though the prometheus query clearly has the asset\_id (i am checking it on the prom web interface)

probe\_success{ **asset\_id** =“685”, asset\_name=“switch4”, environment=“N1”, hierarchy=“2”, instance=“switch4”, job=“ping”, location=“location4”, project=“project1”} 1

---

<div class="post-metadata">

**Author:** ![miguelalfarozgz](https://avatars.discourse-cdn.com/v4/letter/m/4af34b/32.png) [@miguelalfarozgz](https://community.grafana.com/u/miguelalfarozgz)\
**Post date:** [June 5, 2025, 7:34pm UTC](https://community.grafana.com/t/correlate-prometheus-data-with-a-geomap-csv/152041/6 "2025-06-05T19:34:34Z")

</div>

I think I got it (even though to truly confirm, a device should go down, which im not doing to preserve my sanity), the key (we think) is on using **Join by field** and filter it (is a small button on top of the pannel):

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/a/3/a303a67177c5aae6edea2bca7c022c1d2fe706e2.png)

The moment i did that, i was able to pick asset\_name out of the options in OUTER, now is just wait to see if it actually works. Im marking this as resolved for now, if it doesn’t work i’ll try to reopen or i’ll link it.