How can I add a count of entries which has an attribute greater than certain values in Kibana?

[elasticheart]

Hi,

I am using ELK GA 5.0.0. I have an index which contain Name, Gender and Age of people. I would like to create a visualization like below;

I was able to create first 3 columns. I would like to know if it is possible to create the 4th column, which is the count of people, who are older than 50 years. Could someone kindly explain how to achieve this?

Thanks.

[thomasneirynck]

hi @elasticheart,

yes and no.

You can do that filtered count, but you would have to filter up-front.

It'd look something like:

The consequence is that you wouldn't be able to see that together with your other results in the same table. So you would create two tables in the same dashboard.

You would be able to do this in the same table if there were bucketscript-support in Kibana (https://github.com/elastic/kibana/issues/4707). This allows you to write a little script to determine the bucket value. You could do filtering there then.