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 the day for multiple days (hence why I can't just use the date range on the dashboards). After a bit of research, the best resource I found was the following which …

It might be helpful to provide a bit more context on my data. When ingesting, I am mapping a "date" field to @timestamp. So while I do have @timestamp, I also have a simpler date field in each document in the following format: MM/DD/YYYY HH:mm Perhaps I can pull it from that consistently forma…

[image] aaron-nimocks: return doc['@timestamp'].value.getHour(); YES!!! This worked for me as well. Thank you!

For those that come across this in the future, I had an issue with the previous solution and timezone. Seems this was matching UTC which didn't align with the expected output due to how timezones are handled with scripted fields. What ultimately worked was: return LocalDateTime.ofInstant(Instant…

Discuss the Elastic Stack

Hour Scripted Field

Elastic Stack Kibana

aaron-nimocks (Aaron Nimocks) February 5, 2021, 3:46pm 3

return doc['@timestamp'].value.getHour();

This works for me.

Date Histogram Visualization

Topic		Replies	Views
Kibana Scripted Field HourOfDay Kibana painless	4	833	September 19, 2022
Scripted field HourOfDay() Kibana	8	14657	July 10, 2017
Scripted field doc['@timestamp'].date.hourOfDay returs nothing Kibana	6	3286	November 19, 2019
Extracting hour from date field (scripted field) Kibana	6	11058	July 6, 2017
Help to add new field from @timestamp Elasticsearch	3	1461	November 9, 2018

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.

Hour Scripted Field

Related topics