How to get the list of days where no document has been indexed?

Elastic Stack Kibana
1

Hello,

I am looking to extract the days where no documents has been indexed. I am using Data Table to show the number of documents by day. However it does not exclude days where no document has been indexed (count=0). If I could include them, by sorting by count I could get the day list where there is no document.

How could I do that ?

Thanks.

2

Hello,
This is how you do it:
In the Date Histogram aggregation of the table, expand the Advanced JSON input (near the bottom of the box) and add: {"min_doc_count": 0}
This will allow you to see the empty buckets as well.

3

Thanks a lot ! I used the min_doc_count but in the Advanced JSON of the metric...