I have created a pivot report which by default has _time filter, but I want to apply a filter on my other date-time fields also.
I tried doing this, but it is taking my other date-time fields as strings and not as date.
I want to add more than one time filter to the pivot report and all time filters should have the capability to select range of values.
Thanks in advance.
In your search, you need to create an epoch version of each time field you want to filter on. Assuming the time selector was called start_token
and the field was StartTime
, in a format like "2018-08-01 14:21:00", it might look like this in the search...
| eval StartTimeEpoch=strptime(StartTime,"%Y-%m-%d %H:%M:%S")
| where StartTimeEpoch>= $start_token.earliest$ AND StartTimeEpoch < $start_token.latest$
but how to do this in pivot report?