Clickthrough URLs with $__field_ variables don't work with InfluxDB

[amfgomez]

Hello I am trying to insert in each geohash position a URL that it uses a variable, the variable is a tag named entity_id.

I write in the input box "$__field_entity_id" but when it redirects the new page, it shows $__field_entity_id in the variable box and I want the value.

Eg:
1 - entity_id=sensor1

2 - Clickthrough input = someurl.com/d/sadas/var-entity-id=$__field_entity_id

3- In the variable box on another web page entity_id=$__field_entity_id

Thank in advance

[amfgomez]

can you help me?

[amotl]

Dear @amfgomez,

may I humbly ask if you are using "Table data" source for getting data into the panel?

With kind regards, Andreas.

[amfgomez]

Hello Andreas

Thank you very much for responding

I have set the followings configurations:

I have use:

• ?var-filter=name|=|${__field_name}
• ?var-name=$__field_name
• ?var-name=${__field_name} it does not work.

I have used grafana 6.0.1 and grafana-map-panel 0.9

[amfgomez]

Dear @amotl

have you known somthings about the problem?

Thanks you very much in advance.

[MadWalnut]

I have the same issue. I have a Flux query which returns the last value of a field.

from(bucket: "test")
|> range(start: -1y)
|> filter(fn: (r) =>
    r._field == "Crest_electrical_pump"
)
|> last()

This returns: Or how Grafana sees it:

What do I have to fill into the clickthrough URL field to receive back

1. the field name of the clicked bubble (in this case "Crest_electrical_pump")
2. the corresponding value of the field of the clicked bubble (in this case 4.40)

$__from works, as well as $__to. But thats all variables I have found working so far. I have tried everything @amfgomez has above but I just can't get it working.

There seems to have been a change with URL variables starting from Grafana 6.4, not sure it this is something related?

I am running Grafana 7.5.4 and grafana-map-panel 0.15.0.

Thanks in advance for any advice.

[anushajain28]

Hi @amotl,

I am using InfluxDB timeseries as the source and the query returns location and value that is being used by the map to display data. However I am unable to use the location variable in the clickthrough URL. I have tried everything mentioned in the documents as well as what @amfgomez has mentioned above but nothing seems to be working.

Could you please help.

I am running Grafana version: 7.5.10 and panodata-map-plugin 0.16.0

Thanks in advance.