Running Grafana on Windows 10 v9.2.2 & Ubuntu v9.2.3 both with SQLite data source. Both experience the same issue.
I am trying to get Grafana to not modify the time returned in a query based off of UTC or other time zone.
Background: My daughter is a Type 1 Diabetic. The data is stored on her insulin pump based off the time on the pump. I pull that data from her pump manufacturer’s api and all times in that data set is to her pump time, not a time zone. So when we travel and update her pump time, which happens often, I have to go into Grafana update all my queries to update the time off-set that the graphs shows when something happened at the right time.
What I am trying to achieve is to set the time zone (that she currently is physically in [which her pump time is manually set to]) on the dashboard and the dashboard shows the last 3 hours of data without having to go into all the each one of my panels and update them to account for any time offset.
What is happening is that every time she updates her pump time I have to update the dashboard in about 20 places. I have to update the following: date(DateTime,‘-2 hours’) || ‘T’ || time(DateTime,‘-2 hours’) || '.000Z which what I am trying to move away from.
I would like to use the query below without having to add the time zone offset and the data that returns on line 1 @ 2:11AM displays at 2:11AM on the time series graph. I have tried matching the format that the formatted columns transforms them into: see code for actual_time, but when I do, the time series indicates that there is no data to graph.
Is there a way to use Grafana in such a way that it doesn’t modify the data when you query it, see the differences between the results returned, column 1 contains the date & time that columns 2 or 3 should display.’
Any assistance would be greatly appreciated!