Hi There! I would like to include/exclude weekend in the search, So i had created the dropdown for that, I'm getting error in the searches, My Time format is 2023-10-15T13:11:20.000+05:30 ...
See more...
Hi There! I would like to include/exclude weekend in the search, So i had created the dropdown for that, I'm getting error in the searches, My Time format is 2023-10-15T13:11:20.000+05:30 My dropdown is <input type="radio" token="weekends" searchWhenChanged="true"> <label>Weekends</label> <choice value="NOT (day_of_week="saturday" OR day_of_week="sunday")">Exclude Weekends</choice> <choice value="day_of_week="*"">Include Weekends</choice> <default>NOT (day_of_week="saturday" OR day_of_week="sunday")</default> <initialValue>NOT (day_of_week="saturday" OR day_of_week="sunday")</initialValue> </input> My search is `compliance("`console`", now(), -15d@d, mcafee,*, virus_, *, *, *)` | eval day_of_week = lower(strftime(_time,"%A")) | where NOT (day_of_week="saturday" OR day_of_week="sunday") | chart count by virus_global | sort virus_global Thanks!