Hi,
I'm trying to filter the results of the lookup depend upon the time selection from the dashboard. I have date field in the lookup. Below is the sample of the lookup.
ReportedAt Id status
2020-04-09 5:00:00 567 Pass
I'm trying with below logics but it is not working.
|inputlookup file.csv
|eval timeep = strptime('ReportedAt', "%Y-%m-%d %H:%S")
| addinfo
| where timeep > info_max_time and timeep < info_min_time
====
inputlookup file.csv | where Reportedat > $t1.earliest$ and Reportedat < $t1.latest$
Can you please let me know is there a way to display the results depend upon time selection in the dashboard.
... View more