timechart only business hours

[peter_gianusso]

I would like to timechart only events that happened between 9 AM and 5 PM...any help would be appreciated

[jkat54]

Hi,

You need a where clause using date_hour, and then you'll probably want to increase the bins, or use the bucket command to help show time periods when there isnt data:

 index=_internal | where date_hour>=9 AND date_hour<=17 | timechart count bins=1000

[peter_gianusso]

thank you!!

[somesoni2 · Accepted solution]

Try something like this

If date_hour is available in your data

your search  date_hour>=9 AND date_hour<17 | your timechart command

If date_hour is not present,

your search | eval date_hour=strftime(_time,"%H") | where  date_hour>=9 AND date_hour<17 | your timechart command

[jkat54]

if i hadnt taken the screenshot... ;-P, you beat me to it by 25s!

[peter_gianusso]

thank you!!