Creating a panel with one query time offset by 24hrs

Grafana Time Series Panel
1

Hello, I am running Grafana version 8.0.2 and I am trying to create a visualization of the time series for travel time between two points. That part is easy enough, but I want to overlay the travel time data from the day before to see the difference and I can’t seem to find a way to time offset one query within a panel.
Current query I have is:

SELECT mean("value") FROM "min" WHERE ("entity_id" = 'vail_travel_time') AND $timeFilter GROUP BY time($__interval) fill(null)

My end goal is to have one query showing travel time plotted for the day from the beginning of the day(00:00) through the end of the day (24:00). The other query plot should show the same timeframe but -24hrs.

I have been digging through the documentation HERE but not finding what I need. I like examples and lists of options and I am not finding them. Likely I am not looking in the right places for them though.

Any help would be appreciated.

2

Welcome

What is your data source?

3

I am using influxDB 4.5.0 and both are running on my HomeAssistant instance.

1 Like
4

And you want your x axis to show what value; time of day? Broken down by top of the hour, every hour?

5

Ideally x axis would have the day start (00:00) at the left and day end (24:00) at the right. Broken down by hour would be great.

[edit] mixed up left and right.

1 Like
6

Anyone have experience with this type of time offsetting?

7

@superfreq

Would you be willing to update / migrate to Flux? A write-up that might help you get started is here.