Is it not possible to filter (by) field values?

Hello.

I am at a loss with this.

Example:
measurement: responsetime
tag key-value pair of server=1.2.3.4
field key-value pair of ttr=100

In Influx I can write a query:
SELECT COUNT(ttr) FROM timeouts WHERE ttr >= 100 GROUP BY server

This will return how often each server IP had a time to respond over 100ms.

It seems impossible in Grafana as it would look like this:
A FROM default responsetime WHERE {“Here I can only select tags, but not fields”}
SELECT COUNT(ttr) {“Here are lots of options. Math is not working and I see no comparators”}
GROUP BY tag(server)

So am I doing something wrong, or misunderstanding something, or is this simply not possible?

1 Like

You can if you switch to raw query mode (text input mode).

There is an open feature request for this
https://github.com/grafana/grafana/issues/2674

Sorry, just after posting my question I researched further and found the “raw query mode” myself as well.
But thanks for the quick reply and thanks for all the work and development. I love Grafana :slight_smile: