Visualization : count every occurrence of every not null field

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 !

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

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 ?

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

Thank you @markov00.

I did a feature request : https://github.com/elastic/kibana/issues/57090

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