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

Discuss the Elastic Stack

Differences in values between Dev Tools SQL and Visualization

Elastic Stack Kibana

system (system) Closed June 10, 2021, 9:45pm 6

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.

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

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Differences in values between Dev Tools SQL and Visualization

Related topics