Hi all, I am new to elasticsearch/kibana but am having issues matching out the figures between two seemingly similar queries in the Kibana's Dev Tools SQL function and Kibana's visualization tool. The figures are extremely similar but not the same as I would expect. Kibana's visualization tools ret…

reason is SQL query in kibana dev tool is putting out date as is. Kibana visualization is thinking your data is UTC and converting back to your browser time This is problem with timezone. UTC to local time and vice-versa

Differences in values between Dev Tools SQL and Visualization

Elastic Stack Kibana

Christopher_Mello (Christopher Mello) May 13, 2021, 9:36pm 3

Thank you so much @elasticforme, that makes complete sense. Is there a way to make these two queries return the same results in Kibana?

Topic		Replies	Views
Date in index is different from the one visualized in kibana Kibana	4	553	December 12, 2017
Elasticsearch kibana time issue Kibana	3	1252	July 6, 2017
Time difference between dashboard and devTools (ElasticSearch) Kibana dashboard	4	433	May 16, 2023
Kibana TimeZone queries Elasticsearch	1	361	July 6, 2017
Kibana shows 5 hours less than the time posted Kibana	3	694	July 6, 2017

Differences in values between Dev Tools SQL and Visualization

Related topics