Kibana filter with math functions

HI,
Is there any way to write a filter in Lucene with math functions?
in my documments i have filed max_value and actual_value, and i would like to filter all documents where max_value*0.95<actual_value

I dont want to create a scripted field as it would affect other queries and display of information.

thanks

Hello,
There is no way do that sadly.
The scripted field sounds like the only way to achieve that. You could also look into percentiles, but that will only give you aggregated data, not a filter of documents.

1 Like