Kibana Timeserie data on select timerange


I have some index with data.
@timestamp is unix timestamp.

how do for have a timseries grafic with data only between 08h-20h every day ?

hi @Nibeckj,

create a scripted-field on your index pattern that reads out the hour.

There's an example on how to get the hour from a timestamp here . Scroll down to * **Example** : Parse date into hour-of-day". Make sure the @timestamp field is of type: date in the Elasticsearch-mapping.

Then you can create a between filter in Kibana on that scripted-field, where the value needs to be between 8 and 20.

Hello @thomasneirynck,

Thnaks for your answer.
It's good with scriplet.

Hours Of Day : doc['@timestamp'].value.hourOfDay
Days Of Week : doc['@timestamp'].value.dayOfWeek

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