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.
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!
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!
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;
Thank you mayurr98.
Your Answer is very helpful for me.
I'll study more : )
Thanks again.