Display 24h range and 48h range of same value in one graph / MySQL

Grafana Configuration
1

hello,

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?

2

Try creating 2 graphs and using a different Relative time for each.

More here: Multiple time scales on one dashboard - #3 by breathe1one