How to compare value in elasticsearch

Elastic Stack Elasticsearch
1

Hello everyone!

I am having some problems in filtering metrics in elasticsearch.
For example: beside a Total field, I want to filter value in fail column.

function:Total AND fail>0

In the above example: fail>0 is wrong. How can I fixt it? Thanks !

Quang Vũ Blog
Địa chỉ: 432 Nguyễn Thị Minh Khai, Phường 5, Quận 3, Hồ Chí Minh
Phone: +84 977 689 733
Email: quangvublog@gmail.com
Website: https://blog.vu-review.com

2

Try:

function:Total AND fail:[0 TO ]

might work.

3

Thank you so much! I have tried it and I get this reponse "2 of 4 shards failed"

4

Probably because one of the mapping is not correct but I can't really tell with so few information.

5

This is a snapshot of kibana, you can see it easily

image
image.png1113×500 34.2 KB

6

I don't see anything wrong as you described previously. So unless you give all details I'm afraid I cannot help.

7

Can you retrieve and show the mappings for the indices matching the index pattern?

8

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.