# Metric visualization shows no results instead of 0 in count aggregation with terms exclusion **URL:** \ **Category:** Kibana\ **Created:** [October 12, 2020, 4:27pm UTC](https://discuss.elastic.co/t/metric-visualization-shows-no-results-instead-of-0-in-count-aggregation-with-terms-exclusion/251794 "2020-10-12T16:27:24Z")\ **Posts on this page:** 1\ **Showing post:** 8
**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\ **Post date:** [October 14, 2020, 3:58pm UTC](https://discuss.elastic.co/t/metric-visualization-shows-no-results-instead-of-0-in-count-aggregation-with-terms-exclusion/251794/8 "2020-10-14T15:58:39Z")
Thanks, what is the desired outcome with the specification of the `include: "WARNING"` filter in the terms aggregation? what do you want to achieve with that? because this filters the returned bucket returning only buckets with that specific `status` and in your case seems that you don't have buckets on the selected interval to satisfy that clause: [https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html#\_filtering\_values\_4](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html#_filtering_values_4) I'm also seeing that you are specifying also another time filter `last minute` and I think that will not produce the wanted result. I think this can be achieved with TSVB metric visualization as described in this other reply: [Get visualization of missing data](https://discuss.elastic.co/t/get-visualization-of-missing-data/251285/2) --- _[View the full topic](https://discuss.elastic.co/t/metric-visualization-shows-no-results-instead-of-0-in-count-aggregation-with-terms-exclusion/251794)._