I have a Datetime field in my index and I want to show a visualization where I will be able to see in which hours my records are the most frequent. But when I use the Date Histogram and choose to show "per 2 hours" for example, I get intervals like 2022-02-03 15:00 - 2022-02-03 17:00 etc. - the actu…

I suppose scripted fields for hourOfDay is good for you. I can find several similar topics and you may find more. [image] Hour Scripted Field Kibana return doc['@timestamp'].value.getHour(); This works for me.

Discuss the Elastic Stack

Date Histogram Visualization

Elastic Stack Kibana

Tomo_M (Tomohiro Mitani) February 3, 2022, 10:17pm 3

I suppose scripted fields for hourOfDay is good for you. I can find several similar topics and you may find more.

Topic		Replies	Views
Unable to show Hourly Average Kibana	3	505	April 2, 2020
Showing data hourly Kibana	8	1471	August 13, 2021
Kibana bar chart - how to show only hours in the X-axis, not the entire date Kibana	4	893	September 21, 2018
Kibana 8.6 how to show the data per day per hour at the same time Kibana	3	239	December 19, 2023
Scripted Date Aggs Elasticsearch	8	1019	July 5, 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.

Date Histogram Visualization

Related topics