Hi karthikTIL,
Each event has a field called date_hour which has the hour of the day as value, maybe this is of help in your case.
Something like this just to give an example on how to use date_hour :
Your base search date_hour>08 OR date_hour<18 | your next cammond
UPDATE:
Basically you can just add the date_hour and date_wday to the base search like this :
source="file.csv" date_month=august date_hour>08 AND date_hour<18 NOT ( date_wday=Saturday OR date_wday=Sunday )
| bucket _time span=1d
| eval epoch_A=strptime('start_TIME',"%d/%m/%Y %I:%M:%S %p")
| eval epoch_B=strptime('close_TIME',"%d/%m/%Y %I:%M:%S %p")
| eval total_TIME=(('epoch_B'-'epoch_A') / 3600)
| table start_TIME,close_TIME,total_TIME
This way you will only get back results for this time range ( 9am to 5pm ) and only on weekdays Mo - Fr. You can decide if you need the bucket or not, this will group all events into per day slices, which will be used in timechart or chart for example.
For the public holidays you would have to use a lookup.
Cheers, MuS
... View more