Hey, I am trying to find a way to overlay historical data over specified date range by the date time picker on a dashboard on a graph panel. For example, the date time picker on a dashboard set to show data for the last 24 hours. I have a graph panel that should show data for the last 24 hours but I want to also show the same time range but 1 month ago and 1 year ago on the same panel. The data source is MS SQL and looking at generated SQL query, the __timeEpoch macro generates DATEDIFF in seconds, I guess one can probably manipulate that part but what about WHERE clause with __timeFilter macro? Thanks a lot, and any help will be highly appreciated!

[image] Graph panel custom date range Time Series Panel Hi serge1, Grafana has a feature that allows you to override the time for each panel, this option is found at the bottom of the tab of queries, you should only put 7d

I think the issue here is that I want to achieve the functionality of having multiple historical views on the same panel. For examples: The main graph on graph panel will show last 24 hour data. On the same panel I want to be able to show the same 24 hour period but last week, last month, 3 months ago, 1 year ago. It is possible to replicate this functionality by adding multiple queries (A,B,C etc) and then manually setting period of interest and relative historical shifts. However it would be excellent if there was a way to manipulate $__timeFilter(column) macro so that one could specify how many days or months to adjust. Like: $__timeFilter(column, day, -365). The $__timeEpoch(column) macro can also benefit from time shift adjustment. Like: $__timeEpoch(column, day, 1) Hope it makes sense.

Hi serge1, did you ever get a solution for this? I’m also wanting to display this year and last year on the same panel. It doesn’t make sense to have to go back and forth between graphs to measure the differences.

Graph panel overlaying historical data

Grafana Time Series Panel

danielgonzalez August 9, 2019, 12:42pm 2

Topic		Replies	Views
Graph panel custom date range Time Series Panel	6	2826	June 27, 2025
Display Data in Graph Panel for some Custom Range for time in X-Axis InfluxDB query-help	24	21012	May 11, 2020
"Time Range" missing? Time Series Panel	10	11086	February 26, 2020
Different time ranges for each panel on a dashboard Dashboards	2	171	April 20, 2026
Custom time series week,month,year InfluxDB templating	2	1187	October 1, 2023

Graph panel overlaying historical data

Related topics