Create time series panel with data of yesterday, today and tomorrow

Im using Grafana 9.1.0 on Windows 10

I would like to create a Time series panel that always shows yesterday, today and tomorrow’s data, regardless of the time window set. The panel will be implemented on a kiosk display, which always shows today’s data. Relative to today’s date, this panel should also display the data from yesterday and tomorrow (forecast data).

This is the query showing today’s data:
SELECT mean("Prognose_W") FROM "Wetterprognose" WHERE $timeFilter GROUP BY time($__interval) fill(null)
How do I get $timeFilter extended so that the data displayed also includes the previous day and the following day?

I am grateful for all hints that help me to solve my problem!

Kind regards, Achim


What is you data source? sql, mysql, influx?

It is a Influx database
Greetings, Achim