Need help with finding a way in Grafana 11.0.1 to set a panel to show time range 6am to 6pm everyday on one panel. Then on another panel show 6pm to 6am. Then not be able to change the range with the date picker. I’ve tried using the Jason in the 3 dot menu for the panel with timeFrom and timeTo, with no luck.
-Thanks
I need to have the panel stay in that range, no matter what the time picker is changed to.
Yep - understood that from your initial post.
Are you implying that when you copy / pasted the string in the time picker the time range is still moving?
hello @nzeh welcome to grafana community , what datasource you are using ? try to do changes in query about this fixed time.
for postgresql
SELECT *
FROM your_table
WHERE $__timeFilter(time_column)
AND EXTRACT(HOUR FROM time_column) >= 6
AND EXTRACT(HOUR FROM time_column) < 18
Sorry - I only realised now that you have 2x panels in 1x dashboard which you want to split the time range.
Yes as @infofcc3 suggestion by hardcoding in the SQL / query (or using transformation “Filter by”) would be the approach.
I’m using influxql to get my data. I’m guessing I wont be able to do what I want.
I’m guessing I wont be able to do what I want.
Not sure what you mean by this - have you attempted what was suggested?
Sample snippet from Grafana Play: Demo: InfluxDB
As mentioned again, either use transformation “Filter data by values” or direct from the query itself.
Flux query using hourSelection() function to filter time:
|> hourSelection(start: 6, stop: 17)
I’m using influxql to get the data. I’m trying to get the current bottle count for first shift from the times 6am to 6pm on one panel. Then on another panel show the current day for second shift bottles ran 6pm to 6am. From what I’m seeing I can’t get this to work with influxql. If I setup Flux for influxdb then I can filter time ranges from what I’m seeing. I’m not looking for past data, I’m looking for current data.
