# Data table rows with zero count

**URL:** <https://discuss.elastic.co/t/data-table-rows-with-zero-count/129305>\
**Category:** Kibana\
**Created:** [April 24, 2018, 12:17pm UTC](https://discuss.elastic.co/t/data-table-rows-with-zero-count/129305 "2018-04-24T12:17:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![muchypup](https://avatars.discourse-cdn.com/v4/letter/m/a87d85/32.png) [@muchypup](https://discuss.elastic.co/u/muchypup)\
**Post date:** [April 24, 2018, 12:17pm UTC](https://discuss.elastic.co/t/data-table-rows-with-zero-count/129305/1 "2018-04-24T12:17:05Z")

</div>

I am trying to create a report in Kibana to show all entries with zero count older than 60 days. I can create a filter to get the time range, but Kibana is not showing any records with zero count. I can't find any option to enable this.

is this feasible?

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [April 24, 2018, 2:55pm UTC](https://discuss.elastic.co/t/data-table-rows-with-zero-count/129305/2 "2018-04-24T14:55:39Z")

</div>

Can you expand more on this so that I can understand better what you need?  
Do you have a field that is 0 or do you want to see all the days when there was no document ingested in that day?

---

<div class="post-metadata">

**Author:** ![muchypup](https://avatars.discourse-cdn.com/v4/letter/m/a87d85/32.png) [@muchypup](https://discuss.elastic.co/u/muchypup)\
**Post date:** [April 25, 2018, 8:47am UTC](https://discuss.elastic.co/t/data-table-rows-with-zero-count/129305/3 "2018-04-25T08:47:26Z")

</div>

I have a system that reports build events. One entry in ELasticSearch per build with summary data. Each build is performed against a profile. I would like to report every profile which has no build events within the last 60 days.

My X-Axis is Terms, with the field being the profile name. The Y-AXIS is Count aggregation. Kibana shows any entry with a count of 1 or more. I want to show _only_ those terms with a count of zero.

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [April 26, 2018, 2:03pm UTC](https://discuss.elastic.co/t/data-table-rows-with-zero-count/129305/4 "2018-04-26T14:03:05Z")

</div>

I do not think it is possible to display only the ones with no documents. What you could do and still get your reports, would be to create a watch that looks for count \< 1 over the last 60 days in the buckets split with a Terms aggregation on the "profile" field. If you don't have that many profiles, you could create a watch for each of them, which would be a lot safer. You have some example watches here: [https://www.elastic.co/guide/en/x-pack/6.2/watching-meetup-data.html](https://www.elastic.co/guide/en/x-pack/6.2/watching-meetup-data.html)

---

<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:** [May 24, 2018, 2:03pm UTC](https://discuss.elastic.co/t/data-table-rows-with-zero-count/129305/5 "2018-05-24T14:03:11Z")

</div>

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