Hello guys, I’m trying to perform the filtering of the “System_Up_Time” metric by Hostname, within the variables I have this configuration: [winsystem2] Up to this point I have the correct result, all hosts appear, but the problem is that I am not able to obtain the results according to the filt…

Try this: r.host == $host $host is the variable that you created before

Hello Fadjar I tested your tip but it didn’t work, anyway I thank you for trying to help, I leave a capture of how I inserted the variable [host] inserting filter(fn: (r) => r.host == “$host” does not generate errors but I believe that the query searches for the host with the name “$host” and th…

Maybe you can check this example: [image] Grafana I didn’t much have experience using Influxdb

Unfortunately https://play.grafana.org/ for InfluxDB is created and linked with a database of Influx 1.5 or less if I am not mistaken, the queries are totally different, in any case I am still investigating, thank you again. :+1:

Hi @marcelrissardi , Have you fixed this issue? I have the same problem with this thread and I tried long time to fixed it but all failed. Below is my step. ( Grafana7.3+Influxdb2.0-rc3) from(bucket: "flower") |> range(start: v.timeRangeStart, stop:v.timeRangeStop) |> filter(fn: (r) => r.…

The variable works in influxdb dashboard but doesn’t work in grafana dashboard.

Try this: 'r.host =~ "${host}"' Because you use several values, it’s line IN in SQL. If you use exact single value, not multiple value, you can use “==” ,for safety, better use “=~” instead

Hi @fadjar340 , Thank you for your reply. I also tried this . When I add r.host =~ "${host}" the error msg shows "invalid: type error @5:15-5:30: expected regexp but found string". When i add r.host =~ ${host}" the error msg shows "invalid: error @5:22-5:27: undefined identifier host2" [1111-1] […

I know the syntax… try this: r.host =~ /^$host$/ Because it’s need regex…

The solution: In the Grafana query to get the tag values for the variable: import "influxdata/influxdb/schema" schema.tagValues(bucket: "flower", tag: "host") In Grafana’s query: from(bucket: "flower") |> range(start: v.timeRangeStart, stop:v.timeRangeStop) |> filter(fn: (r) => r["_measurement…

How to Filter measurement metrics by Hostname

Grafana InfluxDB

fadjar340 October 13, 2020, 1:58pm 4

Maybe you can check this example:

I didn’t much have experience using Influxdb

Grafana/FluxQL - Tags/Field names in presentation

Topic		Replies	Views
How do I select from InfluxDB 2.0 the list of hosts? InfluxDB	1	3671	July 22, 2020
Influxv2 and grafana multivalue InfluxDB query-help	3	611	October 29, 2022
Grafana/FluxQL - Tags/Field names in presentation InfluxDB	1	1233	October 19, 2020
Flux query help Dashboards influxdb , grafana-ui , flux	2	1254	September 7, 2022
Flux query to list contents of a field to be used for a variable InfluxDB templating , query-help , flux	20	6221	September 7, 2022

How to Filter measurement metrics by Hostname

Related topics