I am new to Grafana (and very basic with MySQL). I managed to set up my “normal” queries and graphs, but the following is a little over my head.
Goal is, to get the average temperature value form across different tables. Each table consists of two data columns, a date (e.g. 2018-11-19 16:00:00) and the temperature value. For example (dates are shortened):
The data sources are different sensor. A new value is written every time, a sensor reports a new value. There is no synchronised update-interval. So the second table might look like:
If possible, Grafana should generate 8 data points out of this (or seven, as 16:04 shows up twice):
16:00 20.01 (optional, as occurring only once for each data series)
I hope I explained the understandable. Help would be appreciated, as every try to add the values ended in a syntax error.