i have build an graph of value “value” in table “rawdata” which shows me the actual values (based on selected timerange in grafana).
The working query looks likes this:
SELECT date AS "time", value FROM rawdata WHERE $__unixEpochFilter(date) ORDER BY date
I need one graph which shows me the values in the last 24h.
And an next graph which shows me the values in the last 48h (average of the value from yesterday and the value from day before yesterday).
Can anyone help me?