Hi,
I’m currently trying to create some boards for my new influx3 setup.
To start with some easy stuff, I tried to create a board, which shows the daily rain value. The value in my database is only increasing and never reset.
I tried some ideas (even with AI support), but I’m currently stuck.
This statement does work in the influxdb3 gui and reports the correct values:
WITH DailyMaxValues AS (SELECT CAST(“time” AS DATE) AS report_date, MAX(“rain_mm”) AS day_end_value FROM rain_mm GROUP BY report_date) SELECT report_date, day_end_value - LAG(day_end_value, 1, 0) OVER (ORDER BY report_date) AS daily_rain_mm FROM DailyMaxValues ORDER BY report_date ASC;
In the grafana query builder just says “no data”.
Are there any obstacles I’m running into oder limitations which I’m not aware of?
Thanks
JJ