# Visualization : count every occurrence of every not null field

**URL:** <https://discuss.elastic.co/t/visualization-count-every-occurrence-of-every-not-null-field/215101>\
**Category:** Kibana\
**Created:** [January 15, 2020, 9:18am UTC](https://discuss.elastic.co/t/visualization-count-every-occurrence-of-every-not-null-field/215101 "2020-01-15T09:18:00Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![GabrielM](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gabrielm/32/47827_2.png) [@GabrielM](https://discuss.elastic.co/u/GabrielM)\
**Post date:** [January 15, 2020, 9:18am UTC](https://discuss.elastic.co/t/visualization-count-every-occurrence-of-every-not-null-field/215101/1 "2020-01-15T09:18:00Z")

</div>

Hello !

Is there a way to count the number of occurrences of each not null field in a visualization (a table seems appropriate to me) Kibana please?

Thank you in advance and have a nice day !

---

<div class="post-metadata">

**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:** [February 6, 2020, 1:51pm UTC](https://discuss.elastic.co/t/visualization-count-every-occurrence-of-every-not-null-field/215101/2 "2020-02-06T13:51:01Z")

</div>

You can create a visualization with the count aggregation and filter the null values in the filter bar. You can save the visualization together with the filter and reuse the viz in a dashboard if you like without specifying the filter again

---

<div class="post-metadata">

**Author:** ![GabrielM](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gabrielm/32/47827_2.png) [@GabrielM](https://discuss.elastic.co/u/GabrielM)\
**Post date:** [February 7, 2020, 9:17am UTC](https://discuss.elastic.co/t/visualization-count-every-occurrence-of-every-not-null-field/215101/3 "2020-02-07T09:17:04Z")

</div>

Hello @markov00. Thanks for your response. Unfortunately, this solution requires to do the aggregation for each field (I have at least 100 fields).

Any solution to do this with all fields automatically ?

---

<div class="post-metadata">

**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:** [February 7, 2020, 9:29am UTC](https://discuss.elastic.co/t/visualization-count-every-occurrence-of-every-not-null-field/215101/4 "2020-02-07T09:29:05Z")

</div>

Hi @GabrielM,  
unfortunately not that I'm aware of. There is no such visualization that allow automatically this kind of statistics on all the fields in an index, and usually it's done field by field, but that's absolutely an useful enhancement. Could you please open a ticket for that [https://github.com/elastic/kibana/issues/new?template=Feature\_request.md](https://github.com/elastic/kibana/issues/new?template=Feature_request.md)

---

<div class="post-metadata">

**Author:** ![GabrielM](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gabrielm/32/47827_2.png) [@GabrielM](https://discuss.elastic.co/u/GabrielM)\
**Post date:** [February 7, 2020, 10:00am UTC](https://discuss.elastic.co/t/visualization-count-every-occurrence-of-every-not-null-field/215101/5 "2020-02-07T10:00:01Z")

</div>

Thank you @markov00.

I did a feature request : [https://github.com/elastic/kibana/issues/57090](https://github.com/elastic/kibana/issues/57090)

---

<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:** [March 6, 2020, 10:00am UTC](https://discuss.elastic.co/t/visualization-count-every-occurrence-of-every-not-null-field/215101/6 "2020-03-06T10:00:08Z")

</div>

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