I started with influx. I install (1.6.4) on a Raspi4. I use the influxdb out node and link them to 3 weathernodes. At the console of influx I see the 3 measurements.
One of them is "TempAussen" [German for Temperature Outdoor].
> select * from TempAussen
name: TempAussen
time value
---- -----
1613497536173210227 5.30
1613497935692276610 5.30
1613498125463913644 4.80
1613498242269076905 4.80
1613498279334013322 4.80
I tryed now to select by using a where clause (I am absolut familar with SQL)
But: select * from TempAussen where [value | "value"] > [5 | "5"] gives no result.
[A|B] means I tried multiple values - like with A and also with B
Also max(value) group by something did not get any result.
I read that this is a "common" problem for beginner - but I did not found "good" explanation.
I use SUFU, Google, ....
I am sure that when I read "the" solution i cry because it would only be a small change.... But - what is "The" solution?