Dashboard with time series panels, but one time series panel with fixed forward looking time

Grafana Dashboards
1

Grafana v11.4.0 (b58701869e) on Raspberry Debian.
InfluxDB, SQLLite DB.

I have a dashboard with a couple of gauges, time series and barcharts.
All relate to the selected timeframe which works fine.

I gather PV forecast data which is future looking (2 days ahead of “now”).
I want one single time series panel to always show the time range “now” → “now+2d”.
my Query currently delivers all data in the PV forecast table:

SELECT UNIXEPOCH(datetime(period_end)) as time, pv_estimate “PV Mittelwert”, pv_estimate10 as “PV 10%”, pv_estimate90 as “PV 90%” FROM solcast WHERE UNIXEPOCH(datetime(period_end)) > UNIXEPOCH(‘now’)

I tried anything with Query Options → Relative Time / Time Shift - nothing worked for me, and its complicated to understand. Why can’t i just define a dynamic timeRange for any panel…

image
image2330×1248 137 KB

it works with a barchart, but here i have very limited design / style options… i would love to use a time series chart.

What i basically want to achieve is this:
from: “now” until: “now+48h”
but without touching ALL other panels… they should stay from “now-24h” until “now”

image
image2383×1509 193 KB

Second question: how can i format the X-Axis, right now it only shoes HH:mm but i would like to have dd.MM.YYYY HH:mm

Thanks!

2

think i resolved my second question at least for a barchart.

image
image2356×455 41.4 KB

it does not work for a time series chart - is there any option to format time on a timeseries chart?

3

very bad hack (and definitely not my preferred solution) is to adjust the timestamp in the query to have it “move to the past” by still being in the future…

SELECT (UNIXEPOCH(datetime(period_end))-(24*3600)) as time…

image
image2356×1111 211 KB

4

Hi, I did this in the past.

however I used Flux language.

I can’t give the solution but the way i did it it was to apply a “time shift” to one of the queries to move my timestamps. and then after having 2 different queries processed differently I combined them in flux, or maybe I just used the different queries in grafana on the same dashboard as Query A and B?

the trick is to do all the preprocessing on the query side and use grafana just to display it as a normal time series.

Sorry If can’t give you more detail I have been inactive for a year and memory is kind of rusted.