How do I search for business hours or non-business hours during the month?

[superhm]

I would like to search for business hours(09:00 ~ 18:00) or non-business hours(18:00 ~ 09:00) during the month.
How do I set the time options?
Please help me.

[mayurr98 · Accepted solution]

hey try this

for business hours

index=<your_index> earliest=@mon latest=now date_hour>=9 date_hour<18

for non-business hours

index=<your_index> earliest=@mon latest=now date_hour>=18 OR date_hour<9

Also if you want to exclude Saturdays and Sundays then you should add NOT (date_wday=saturday OR date_wday=sunday) in your main search

let me know if this helps!

[MarcoDV]

your commands are no longer valid.
help me, the requests they made me are:
(a) bar chart for out of hours access;

(b) bar graph for access during business hours;

[superhm]

Thank you mayurr98.
Your Answer is very helpful for me.
I'll study more : )
Thanks again.