Hi,
I want to create a dashboard, where a user has a drop down input to select a named time frame ($value$). The start and end date of the time frame are defined in a lookup table.
Each of my events has a milestone date. I want to filter to those events where the milestone date is between the start and end date from the lookup table.
I tried something like this:
index=my_index
| where milestone_date_epoch > [inputlookup mapping_lookup WHERE time_frame = $value$
| eval startdate = strptime(Start_date, "%Y-%m-%d")
| return startdate]
| where milestone_date_epoch < [inputlookup mapping_lookup WHERE time_frame = $value$
| eval enddate = strptime(End_date, "%Y-%m-%d")
| return enddate]
But I get an error message 😞 Can you help me to get this fixed?
... View more