I am user of Open source version of Graphana. I had downloaded the source code and installed it in on Linux box and it works fine.
I am currently using Grafana for visualizing data from a bunch of electrical sensors connected to a gateway. I collect data from sensor and store them into a influx database which is running on the same Linux box. Sensor data is stored in time series format. Using influx db query I am able to verify that the stored data.
Grafana as a visualization software is working fine. But issue I am facing is with Graphs. (Not with other panels)
The X-axis does not show the current time, instead is show the current time at UTC and display the data corresponding to it. I had checked my machine time at it is correct.
To describe the problem in a bit detail
- Let us say, I had set the timezone at UTC (Settings->Time Options-> Timezone) Though, I am currently at GMT + 5:30 hours. (India)
Now assume, current time is 20:00 (8:00 PM) Graphan (graphs) will display the data corresponding to 14:30 (2:30 PM). In other words the Graphs show the x-axis which exactly 5:30 hours behind and the data corresponding to that time point. I have Gauge widget to display the current data. It is displaying the correct values corresponding to current time.
- Let us says I had set timezone to “Local Browser time” the behaviour changes this time. Now the X-axis shows the current time. IF the current time is 20:00 It shows the time scale from 14:30 (2:30 PM) to 20:00 (8:00 PM) which is perfect. However the data it shows corresponds to a given time point, is exactly 5:30 hours behind. That means if I am looking at data point correspoding to 20:00 it will be showing the data that was collected against the time 14:30 (exactly 5:30 hours back). Here there is mis match between X-values and the corresponding value on Y-axis.
To debug the problem:
(i) I had checked the local machine where browser is running (It is windows machine) and its time zone is correctly set to UTC + 5:30 PM. I checked the time zome and clock on the Linux box where Grafana and Influx is installed that is also correct.
(ii) The influx database query I am using to pull data to Grafana is
SELECT “Humidity” FROM “defaultdb”.“autogen”.“ClimateEvents”
When I run this query in Influxdb prompt it shows correct values
(iii) I checked through Query inspector there also the data is correct.
(iv) I had checked the defaults.ini file I did not see anything related to Timezone settings.
Can you help me to sort out this issue ?
I am using Internet explorer for accessing Graphana