Overlay time chart to compare rate of last 7 days in time frame 1 day

Grafana
1

Hi
need overlay time chart to compare rate of last 7 days in time frame of 1 day.

something like this:
Screenshot 2024-08-06 113340

is it possible in Grafana?

FYI: DataSource is a Postgres

here is my query:

SELECT
  $__time(timestamp),
   server,
  count(rate) 
FROM
  mytable
WHERE
    server = 'mysrv'  SAMPLE BY 1h
GROUP by
  time,
  server

Any idea?
Thanks

2

It can be done in your query, Grafana will just visualize the data that your query returns.

3

Try something like this: