Date Histogram Visualization

[kibanauser4]

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 actual date is included but I'm only interested in the hours summed up over the days. Can Kibana somehow ignore the date and just show the hour intervals?

[bhavyarm]

Would using the minimum interval - hour help?

Thanks,
Bhavya

[Tomo_M (Tomohiro Mitani)]

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

Hour Scripted Field

return doc['@timestamp'].value.getHour(); This works for me.

[kibanauser4]

This is exactly the thing I needed, thanks a lot!