Can we add more than one time field to the dataset or add more than one time filter to the pivot?

[chinmayc469]

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.

[DalJeanis]

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$ 

[chinmayc469]

but how to do this in pivot report?