Show field value depending on an another specific field value

Grafana InfluxDB
1

A have some time based measurements and they are working very well, I can show on Grafana different field values. But how to show a tag value depending on another field value?

tag_key field1 field2
A 211 10
B 154 20
C 123 20
D 343 10
E 343 10
F 367 10
G 343 20
H 435 25

For example. I want to show the values of field1 only if field2 values are 10 at the same time. Ist that possible with Grafana? I didn’t found any possibility. Datasource is influxdb. Thank you

2

The result should be as follows.

tag_key field1 field2
A 211 10
D 343 10
E 343 10
F 367 10

I want to show on the panel only field1 values, where field2=10 and really don’t know how this could be done. Thank you

3

Did you try something like

SELECT field1 FROM measurement WHERE field2=10
?