Hi there, I am trying to select a range of values with a condition. My condition is select the values where the “key” of this values is in the range between Key>1 and key<200. My Influx database has 2 measurements, field “value” and a tag field “key”.
I need a query to select this values in my key range to visualize them into Grafana.
I already try something like
select * from where “key” > ‘1’ and “key” < 200
but It is not working. Nevertheless I can select the values from one single key:
select value from leuko where “key” = ‘2’
That is working. How could I do the same but just not for the values with the key ‘2’ but also for all the values between ‘2’ and ‘200’? Thanks
