# Table which shows number of events where field exists / not exists

**URL:** <https://discuss.elastic.co/t/table-which-shows-number-of-events-where-field-exists-not-exists/216618>\
**Category:** Kibana\
**Created:** [January 27, 2020, 8:22am UTC](https://discuss.elastic.co/t/table-which-shows-number-of-events-where-field-exists-not-exists/216618 "2020-01-27T08:22:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![asp](https://avatars.discourse-cdn.com/v4/letter/a/9fc348/32.png) [@asp](https://discuss.elastic.co/u/asp)\
**Post date:** [January 27, 2020, 8:22am UTC](https://discuss.elastic.co/t/table-which-shows-number-of-events-where-field-exists-not-exists/216618/1 "2020-01-27T08:22:21Z")

</div>

Hi,

We modified our log data to extend the information which is available in kibana.  
So we introduced a new field I need to check if the new field is present in all events, if not I want to have a table where I can see which log and which called method is missing the new field.

I already checked, I have a lot of events where the new field is missing. To support the developers I need a table like this:  
`| logType | method | count new field exists | count new field does not exist |`

logType and method are fields which are already present all events.

I have no clue how I can put the count of events where the new field is present / missing into a columns.  
Can I use the json input to check the field for existance?

Thanks a lot, Andreas

---

<div class="post-metadata">

**Author:** ![asp](https://avatars.discourse-cdn.com/v4/letter/a/9fc348/32.png) [@asp](https://discuss.elastic.co/u/asp)\
**Post date:** [January 27, 2020, 8:34am UTC](https://discuss.elastic.co/t/table-which-shows-number-of-events-where-field-exists-not-exists/216618/2 "2020-01-27T08:34:24Z")

</div>

writing about the topic helps 😉

Found a solution:  
I added a filter bucket which implements to filters:

```
newField: *
not newField: *

```

This way I can group on the new field and place the info in the column.  
btw, I used enhanced table plugin, so I was able to add the information pivot-like to the rows 🙂

---

<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:** [February 24, 2020, 8:34am UTC](https://discuss.elastic.co/t/table-which-shows-number-of-events-where-field-exists-not-exists/216618/3 "2020-02-24T08:34:40Z")

</div>

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