I’m currently displaying the temperature and humidity values of a room in real time.
On this graph, I’d like to identify the time zones where:
the temperature is between 12 and 15°C AND the humidity between 55 and 75%.
I’d like the time zones that match this condition to be displayed on the graph (as green time bands).
How can I achieve this?
Thanks for reading, and for your help!
Please provide your grafana version and your data source and at minimum some data structure, schema and some sample data
Thank you @yosiasz !
I apologize for the late answer.
I use Grafana v10.0.3 with influxDB Chronograf Version: 1.10.1, integrated in HomeAssistant.
My data look like this:
I would like to be able to colorize the time zones where:
the temperature is between 12 and 15°C AND the humidity between 55 and 75%. That would look like this:
(It’s just an example with fake query results)
So far, I managed to create an annotation, with a query:
SELECT distinct("humidity") FROM "%" WHERE ("entity_id" = 'cave_2_humidity' OR "entity_id" = '0x00124b0024cd6d76_humidity' >= 55)
For the moment I keep it simple with the humidity only, but my goal is to colorize the time zone where the temperature is between 12 and 15°C AND the humidity between 55 and 75%.
But nothing shows up atm.
Thank you again for your advises !