# Visualisations - Display records with zero count **URL:** \ **Category:** Kibana\ **Created:** [October 4, 2018, 10:58am UTC](https://discuss.elastic.co/t/visualisations-display-records-with-zero-count/151035 "2018-10-04T10:58:20Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![singhster](https://avatars.discourse-cdn.com/v4/letter/s/a9adbd/32.png) [@singhster](https://discuss.elastic.co/u/singhster)\ **Post date:** [October 4, 2018, 10:58am UTC](https://discuss.elastic.co/t/visualisations-display-records-with-zero-count/151035/1 "2018-10-04T10:58:20Z")
I'm trying create a visualization and find IDs where there is a zero count over a given time period. For example, if we have data such as ID Date 1 01-OCT-2018 2 01-OCT-2018 1 02-OCT-2018 I'd like a visualization that would report that ID=2 has zero records for the period of 2nd Oct 2018. I don't really care which chart type it's displayed on - but is this possible in Kibana? ---
**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:** [October 4, 2018, 11:33am UTC](https://discuss.elastic.co/t/visualisations-display-records-with-zero-count/151035/2 "2018-10-04T11:33:47Z")
You can't do that in a visualization per se, but you can achieve this using the Advanced Threshold alert in Watcher. ![watcher_advanced](https://us1.discourse-cdn.com/elastic/original/3X/c/b/cbc11718d0e633577f5134d0a839caca99fe83d6.png) You can't really display it in a Kibana dashboard unless you do something a bit convoluted: 1. Set it to the Log action. 2. Set logstash to auto-ingest the Kibana log and filter only these watcher messages. 3. You can create a visualization based on these messages. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 1, 2018, 11:33am UTC](https://discuss.elastic.co/t/visualisations-display-records-with-zero-count/151035/3 "2018-11-01T11:33:50Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.