Hello everybody,
I’m a happy Grafana user but in these days I changed my application setup and now I can’t figure out what is going wrong.
I made a dashboard with few graphs and few tables, but the time representation looks different: the time in the table is shown correctly (the timezone UTC+2 is right, got from browser settings) but in the graph looks that the time values are shown in UTC, while the filter limits correctly the last 6 hours.
Did I misconfigured anything?
-
I’m using Grafana 5.04 on Linux system
-
The database is MySQL
-
All the times are stored in the database in UTC format
-
The select query I use to populate the graph is
SELECT
UNIX_TIMESTAMP(TimeTemperature) as time_sec,
Temperature as value, ‘Sensore_Filtro’ as metric
FROM TempCheck WHERE $__timeFilter(TimeTemperature) AND Sensor=2
ORDER BY TimeTemperature ASC -
I already tried to replace UNIX_TIMESTAMP(TimeTemperature) with UNIX_TIMESTAMP(CONVERT_TZ(OraRilevamento,‘+00:00’,‘+02:00’)), the times now are displayed correctly,
but the graph has a big hole at the beginning (seems the “last 6 hour” filter is not interpreted correctly) and also the notifications are not working at all
I hope you can help me! Thank you in advance!