Displaying time zones that matches a condition

Grafana Dashboards
1

Hello,
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!

2

Welcome @quarttemps

Please provide your grafana version and your data source and at minimum some data structure, schema and some sample data

3

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:

image
image1247×741 170 KB

image

image

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:

image
image1371×888 201 KB

(It’s just an example with fake query results)

So far, I managed to create an annotation, with a query:

image
image1437×825 51.2 KB

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 !
QT