# How to filter based on aggregation results?
**URL:** https://discuss.elastic.co/t/how-to-filter-based-on-aggregation-results/211332
**Category:** Kibana
**Created:** [December 10, 2019, 4:14pm UTC](https://discuss.elastic.co/t/how-to-filter-based-on-aggregation-results/211332 "2019-12-10T16:14:38Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@guibarati](https://discuss.elastic.co/u/guibarati)
#### Post date: [December 10, 2019, 4:14pm UTC](https://discuss.elastic.co/t/how-to-filter-based-on-aggregation-results/211332/1 "2019-12-10T16:14:39Z")
How can I filter a table view on Kibana based on the aggregation results?
I've seen a lot of recommendations to use document count, but it doesn't work for my use case.
I have network logs where a single document indicates how much data was transferred during a tcp connection. So the field bytesReceived has the number of bytes received by a host during a connection.
On Kibana I want to create a table view with the "host" bucket and the aggregation as "sum of -\> bytes received" But I only want to see the hosts where the sum of all bytes received in the last 24 hours is: greater than, lower than or equal to a number. (With separate filters for each case)
A single document can indicate that a host "bytesReceived" in 24h was greater than X number.
Or the sum of all "bytesReceived" for a host in multiple documents was greater than X number.
How can I filter it on Kibana table view?
To clarify, for example:
The sum of "bytesReceived" in 100 documents could be equal 3000
While the sum of "bytesReceived" for 2 other documents could be 4000000
And I want to show only lines where sum of "bytesReceived" are greater than 1000000 for example.
Thanks!
---
### Author:  [@guibarati](https://discuss.elastic.co/u/guibarati)
#### Post date: [December 11, 2019, 5:32pm UTC](https://discuss.elastic.co/t/how-to-filter-based-on-aggregation-results/211332/2 "2019-12-11T17:32:21Z")
Up! - Any advice on this?
Please, let me know if this needs further clarification.
---
### Author:  [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)
#### Post date: [December 19, 2019, 1:03am UTC](https://discuss.elastic.co/t/how-to-filter-based-on-aggregation-results/211332/3 "2019-12-19T01:03:27Z")
@timroes can we please get some help here?
Thanks,
bhavya
---
### Author:  [@timroes](https://discuss.elastic.co/u/timroes)
#### Post date: [December 19, 2019, 10:11am UTC](https://discuss.elastic.co/t/how-to-filter-based-on-aggregation-results/211332/4 "2019-12-19T10:11:40Z")
Hi,
this is unfortunately not possible. Elasticsearch can do that via the [bucket selector](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-bucket-selector-aggregation.html) aggregation, but we don't support that yet in Kibana.
You can follow [https://github.com/elastic/kibana/issues/17544](https://github.com/elastic/kibana/issues/17544) to track support for that feature in Kibana.
Cheers,
Tim
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 16, 2020, 10:11am UTC](https://discuss.elastic.co/t/how-to-filter-based-on-aggregation-results/211332/5 "2020-01-16T10:11:47Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.