topic Can we add more than one time field to the dataset or add more than one time filter to the pivot? in Getting Data In

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

chinmayc469 — Wed, 01 Aug 2018 11:15:34 GMT

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.

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

DalJeanis — Wed, 01 Aug 2018 16:02:02 GMT

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$

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

chinmayc469 — Thu, 02 Aug 2018 09:12:41 GMT

but how to do this in pivot report?