I’m using Grafana OSS v13.0.1, and want to put multiple panels on a dashboard, each with different time ranges. Examples of ranges I would like to use would be current financial year (July 1st to June 30th), current month, previous month (where ‘current’ means ‘now’). I would like to hide the time picker on the dashboard itself and use specific ranges for each panel.
I’m pulling the data from a ClickHouse database, and I can easily select the correct range of data for each panel in my SQL queries (i.e. even just completely ignoring the dashboard $__fromTime / $__toTime variables).
For single value panels like Stat, I can simply output the data ‘raw’ and ignore the selected time range, so that’s fine, however using for example a regular Time Series chart, it always still only displays the time range based on the dashboard’s time picker.
Given a query that only outputs data in the desired time range, can I override the display range of the Time Series panel accordingly? I have tried to use the Relative time and Time shift query options to achieve this, but seem to be failing
I have a handful of dashboard variables that define the various ‘start’ and ‘end’ dates for the different queries (for example fy_start and fy_end based on the selected financial_year variable). I then use those variables in the various SQL queries to scope the results of each accordingly.
However if for example the query is for last financial year, the SQL query correctly returns results from 2024-07-01 to 2025-06-30, however unless I then manually adjust the dashboard’s time range to the above dates, the time series panel doesn’t show any data (because it’s only showing whatever date range the dashboard is currently set to, e.g. ‘Last 24 Hours’ or whatever. Conversely, if I just hardcode the dashboard range to something like ‘2000-01-01’ to ‘2099-12-31’ (and then hide the time picker), the time series panel shows that entire range and not just the section that has data based on the variables.
