I am trying to add a Time filter element to a Canvas Workpad, but each time I do it breaks the existing table or chart elements.
I think that I have followed all online guidance/tutorials to the letter e.g.
Both are quite clear. Set up table with SQL (the SQL query works fine in table, co-ord plot, debug data, etc.). As soon as Add element > Filter > Time Filter is selected the following error appears:
Whoops! Expression failed
Expression failed with the message:
[essql] > Unexpected error from Elasticsearch: [verification_exception] Found 1 problem line 1:30: Unknown index [my_index]
I haven’t even changed the settings of the filter column at this point. Once changed to our time field startDate, the error is unchanged. The index pattern is available and works fine until the time filter is added.
The dropdown select filter works perfectly and as expected. startDate is type of date, so should work with the time filter (fine in Discovery too). Therefore, I can only conclude that it is a bug. There is nothing else in config to control the behaviour, unless I'm missing something fundamental.