# Find missing values from index

**URL:** <https://discuss.elastic.co/t/find-missing-values-from-index/178008>\
**Category:** Kibana\
**Created:** [April 23, 2019, 10:48am UTC](https://discuss.elastic.co/t/find-missing-values-from-index/178008 "2019-04-23T10:48:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![singhster](https://avatars.discourse-cdn.com/v4/letter/s/a9adbd/32.png) [@singhster](https://discuss.elastic.co/u/singhster)\
**Post date:** [April 23, 2019, 10:48am UTC](https://discuss.elastic.co/t/find-missing-values-from-index/178008/1 "2019-04-23T10:48:16Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [April 24, 2019, 6:44pm UTC](https://discuss.elastic.co/t/find-missing-values-from-index/178008/2 "2019-04-24T18:44:09Z")

</div>

Hello,

You can chart missing values

 ![37%20PM](https://us1.discourse-cdn.com/elastic/original/3X/9/9/99f26ec5eaaf5dfcc3270f13ae79f88c570665a2.png) in Kibana.

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

Thanks,  
Bhavya

---

<div class="post-metadata">

**Author:** ![singhster](https://avatars.discourse-cdn.com/v4/letter/s/a9adbd/32.png) [@singhster](https://discuss.elastic.co/u/singhster)\
**Post date:** [April 25, 2019, 12:53pm UTC](https://discuss.elastic.co/t/find-missing-values-from-index/178008/3 "2019-04-25T12:53:33Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![singhster](https://avatars.discourse-cdn.com/v4/letter/s/a9adbd/32.png) [@singhster](https://discuss.elastic.co/u/singhster)\
**Post date:** [May 7, 2019, 8:23am UTC](https://discuss.elastic.co/t/find-missing-values-from-index/178008/4 "2019-05-07T08:23:32Z")

</div>

Anyone got any ideas if this is possible?

---

<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:** [June 4, 2019, 8:23am UTC](https://discuss.elastic.co/t/find-missing-values-from-index/178008/5 "2019-06-04T08:23:37Z")

</div>

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