I am trying to produce a dashboard that has some visualizations but also some data tables. In order to produce the results I need in the data tables, there are times that I must filter based on the time of day. For example, while my date range may be Jan1@00:00-Jan31@23:30, I need to further limit…

My solution to this ultimately was to create a scripted field that pulled the hour from the @timestamp [image] Hour Scripted Field Kibana I am trying to create a scripted field that is the hourly value of each document. The ultimate goal is to filter by specific hours of …

Excellent. I was able to confirm and replicate. The one difficulty I see here is this would seem to require a filter entry for each day. This may not be a problem for shorter analysis but if we were to want to pull up a month or a year, it would be difficult to create one of these for each day (t…

[image] Scripted field HourOfDay() Kibana Hi, I want a field containing the hour of the day for each elasticsearch document. The easiest way would be to parse @timestamp into a hour_of_day field but that means I would have to reindex all my data. I saw another solution …

Discuss the Elastic Stack

Time of Day filter

Elastic Stack Kibana

lukas (Lukas Olson) February 4, 2021, 7:05pm 2

Sure, you should be able to filter by using the "add filter" dialog when creating the data table visualization:

Let me know if that helps.

Topic		Replies	Views
How to filter certain range of hours for each day in bar chart? Kibana	2	3843	December 5, 2016
Scripted Field using timestamp Elasticsearch	1	758	July 20, 2020
Scripted field doc['@timestamp'].date.hourOfDay returs nothing Kibana	6	3281	November 19, 2019
Timelion filter data by hour Kibana timelion	5	1054	June 13, 2018
Showing data hourly Kibana	8	1635	August 13, 2021

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.

Time of Day filter

Related topics