I want to make a graph that displays hourly forecasts (temperature, rain, etc.). I have data coming from OpenHAB that saves in a InfluxDB2 database. For each forecast, I have the following in InfluxDB:
where XX is a number between 00 (now) and 48 (hours). I can retrieve the data in Grafana with:
|> range(start: -2h)
|> filter(fn: (r) =>
r._measurement =~ /weather_h[0-4][0-9]_temperature/
I want to make a graph that uses weather_hXX_timestamp on the X axis, and weather_hXX_temperature on the Y axis. Seems simple enough, but I can’t figure it out. Note there are no missing values in the ranges, they include all values from 00 to 48.
and a few others
I can’t wrap my head around this. Where to start?
Any help will be greatly appreciated