Hey there, I’d like to generate a table in Grafana which shows the temperature at a specific time of day for each day.
I’m querying InfluxDB which holds sensor data recorded every 60 seconds. From that, I’d like to display a list that shows values from 2PM each day.
I think aggregating by mean value from 13:50 to 14:10 would be best.
How can I select the time of day (as well as time window 13:50 to 14:10) for the data points?
My end result should look like
09.09.2020 2PM | 23.00°C
08.09.2020 2PM | 20.50°C
07.09.2020 2PM | 22.22°C
…