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 GRO…

I have added 2 hours manually in the SQL query like this: SELECT HISTOGRAM(pruebafecha + INTERVAL 2 HOURS, INTERVAL 1 MINUTES) AS Hora, ip_origen, COUNT(ip_origen) as Cont FROM autenticacion WHERE pruebafecha > NOW() - INTERVAL 1 HOURS AND ip_origen IS NOT NULL GROUP BY ip_origen, Hora ORDER BY …

Wrong Canvas timezone

Elastic Stack Kibana

dgonzalezp July 16, 2019, 6:09am 6

Thanks for reply Tims

I did but still not working with the same error message:

"[mapColumn] > Can not cast 'render' to any of 'datatable'"

Is it possible to show old logs(previous year) in the ELK a visualization?

Topic		Replies	Views
Canvas Time sets Kibana canvas	4	1306	August 21, 2019
How can I change the timezone on Kibana? Kibana	3	1422	December 26, 2023
Canvas date function time zone support Kibana canvas	3	1572	February 13, 2022
Kibana Canvas not providing correct tome format Kibana canvas	3	353	October 29, 2020
How to handle Daylight Savings Time in Kibana Canvas? Kibana canvas	2	797	November 30, 2020

Wrong Canvas timezone

Related topics