Find missing values from index

Is there a way to find missing values in Kibana (v 6.5.2)? For example, we have 100 venue_ids, and we expect to see a record for each venue_id in an index every day. Let's say on day 1 we have all 100, but in subsequent days, some venue_ids do not appear. Is there a suitable visualization for this?

Apologies if this is a duplicate - but I've not seen a question like this for a few years, and I'm not sure if it is now possible.


You can chart missing values

in Kibana.

That should def help. Please note it does depend on your field being of type string.


Hi Bhavya,

Thank you for your response, but I'm not sure if it will help with my query. Perhaps I have not explained my requirement very well. Given data such as this

  • Venue_ID = 1, Date = 01-JAN-2019
  • Venue_ID = 2, Date = 01-JAN-2019
  • Venue_ID = 2, Date = 02-JAN-2019

Our expectation is that Venue_ID 1 should have a record for all dates, but it doesn't have a record for 02-JAN-2019 in the example above. Is there a visualization that will help us highlight this?

Anyone got any ideas if this is possible?

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