Field calculate with painless script and filter

Elastic Stack Kibana
1

Hello,

We have a field in ELK 7.1.1 calculate like that :
name field : RESULT
script : doc['ORIG1BEFORE'].value-doc['ORIG2AFTER'].value

when we display it, it display 0 or other no null value.

When we do a filter in visualize filter with RESULT >0 it display some value with 0 value

We don't understand why ...

if you have ideas.. thanks in advance

image
image.png1379×497 28.5 KB

2

Can you describe your index shape a little more? What is value-doc?

3

Can you show us an example JSON document?

4

hello,
it's the value of ORIG1BEFORE minus value of ORIG2AFTER

5

in fact we put FEE>1 and it's work like expected