I have created a line graph in canvas but in the time line I got a wrong timezone with the next SQL query:
SELECT HISTOGRAM("@timestamp", INTERVAL 1 MINUTES) Hora, ip_origen, COUNT(ip_origen) as Cont
FROM autenticacion WHERE "@timestamp" > NOW() - INTERVAL 10 MINUTES
AND ip_origen IS NOT NULL GROUP BY ip_origen, Hora
ORDER BY Hora
The preview is this:
As you can see the correct hour is 13:00 but in the graph there are 2 hours less:
I would like to know if there is a way to change the time zone, I have tried including tz="UTC+2" in the expression editor with no luck and I have readed something about moment.js but honestly I dont know what that is and I didnt find any tutorial.
Help me please!