# Visualization: Display missing values on filter aggregation

**URL:** <https://discuss.elastic.co/t/visualization-display-missing-values-on-filter-aggregation/238586>\
**Category:** Kibana\
**Created:** [June 25, 2020, 2:23am UTC](https://discuss.elastic.co/t/visualization-display-missing-values-on-filter-aggregation/238586 "2020-06-25T02:23:56Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![kimjavier43](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kimjavier43/32/67117_2.png) [@kimjavier43](https://discuss.elastic.co/u/kimjavier43)\
**Post date:** [June 25, 2020, 2:23am UTC](https://discuss.elastic.co/t/visualization-display-missing-values-on-filter-aggregation/238586/1 "2020-06-25T02:23:56Z")

</div>

Hello,

Is there a way to include missing fields in filters aggregation like in terms aggregation?

Thanks,

---

<div class="post-metadata">

**Author:** ![Emanuil](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/emanuil/32/36783_2.png) [@Emanuil](https://discuss.elastic.co/u/Emanuil)\
**Post date:** [June 25, 2020, 10:32am UTC](https://discuss.elastic.co/t/visualization-display-missing-values-on-filter-aggregation/238586/2 "2020-06-25T10:32:46Z")

</div>

You could nest [https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-missing-aggregation.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-missing-aggregation.html) under your terms agg?

Could you post your terms agg and also what you want the final response to look like? Just take the term agg response and edit it by hand, showing what you want to achieve.

---

<div class="post-metadata">

**Author:** ![kimjavier43](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kimjavier43/32/67117_2.png) [@kimjavier43](https://discuss.elastic.co/u/kimjavier43)\
**Post date:** [June 26, 2020, 12:35am UTC](https://discuss.elastic.co/t/visualization-display-missing-values-on-filter-aggregation/238586/3 "2020-06-26T00:35:17Z")

</div>

@Emanuil,

missing aggregation is deprecated from ES. I already got it using the filter below on filters aggregation. Our use case favors filters agg for flexibility than term agg.

`{"bool":{"must_not":{"exists":{"field":"{value}"}}}}`

Thank you.

---

<div class="post-metadata">

**Author:** ![Emanuil](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/emanuil/32/36783_2.png) [@Emanuil](https://discuss.elastic.co/u/Emanuil)\
**Post date:** [June 26, 2020, 1:47pm UTC](https://discuss.elastic.co/t/visualization-display-missing-values-on-filter-aggregation/238586/4 "2020-06-26T13:47:51Z")

</div>

Thanks a lot for coming back to post your solution!

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 26, 2020, 2:09pm UTC](https://discuss.elastic.co/t/visualization-display-missing-values-on-filter-aggregation/238586/5 "2020-06-26T14:09:19Z")

</div>

> [@kimjavier43](#):
>
> missing aggregation is deprecated from ES.

Where did you get this?  
The following code does not produce any deprecation notice AFAIK.

```auto
DELETE /sales
PUT /sales/_doc/1
{
  "foo": "bar",
  "price": 10
}
PUT /sales/_doc/2
{
  "foo": "bar"
}
POST /sales/_search?size=0
{
    "aggs" : {
        "products_without_a_price" : {
            "missing" : { "field" : "price" }
        }
    }
}

```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 24, 2020, 2:09pm UTC](https://discuss.elastic.co/t/visualization-display-missing-values-on-filter-aggregation/238586/6 "2020-07-24T14:09:28Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.