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? 
Asked
Active
Viewed 6,255 times
5
Enayat
- 3,904
- 1
- 33
- 47
-
Hello, I am having the same problem. Did you ever figure out how to "organize" the results by the aggregation (sort results by the count* function)? – HC LW Oct 18 '21 at 16:33
-
Hello, No. I have not checked it out recently, but by that time there was such features in Kibana – Enayat Oct 20 '21 at 17:24
1 Answers
1
You can augment aggregation query within advanced field
It will be added to request as shown on picture
Another question is what to put into this field. You can check script values for sum aggregation
pkhlop
- 1,824
- 3
- 18
- 23
-
2Could you please elaborate more? What is test? I want to filter the "sum of fields". – Enayat Apr 04 '18 at 12:46