Find missing values from index

[singhster (Simon Singh)]

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.

[bhavyarm]

Hello,

You can chart missing values

in Kibana.

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

Thanks,
Bhavya

[singhster (Simon Singh)]

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?

[singhster (Simon Singh)]

Anyone got any ideas if this is possible?