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!