CODEWITHSUNDEEP
elasticsearchkibanakibana-6
Enayat
Enayat

Reputation: 4042

How to filter the aggregation results in Kibana (elastic search)?

I want to filter the elastic search aggregation results in Kibana (v6.2). For example, I want to show only sum of hours those that are more than 100 (like HAVING command in SQL). I know that we can filter the results in filter section over other fields, but I don't know how to apply the filter on aggregation functions. I tried to use post_filter in filter section in Kibana, but it didn't work. Any ideas? enter image description here

Upvotes: 5

Views: 7299

Answers (1)

pkhlop
pkhlop

Reputation: 1844

You can augment aggregation query within advanced field

It will be added to request as shown on picture

Kibana advanced aggregation fields

Another question is what to put into this field. You can check script values for sum aggregation

Upvotes: 1

Related Questions