Hello, I've been having issues with KQL queries using scripted fields. Specifically, queries on numerical fields using operators such as "<=" or ">" throw the following error when using a Lens :
[lens_merge_tables] > [esaggs] > EsError
It looks like I get a more detailed error using an Aggregation (see attached screenshot).
Interestingly enough, the KQL operator ":" works just fine.
All I am doing in the scripted field is multiplying a numerical field by 2, and there are no missing values.
I am at a complete loss since the Kibana documentation clearly states that all KQL operators are compatible with scripted fields.
I absolutely need to use KQL filtering since I'm using a Filter Ratio in the TSVB tool.
Your support would be much appreciated. Thank you