# How to show '0' in empty cells in heatmap in kibana 7.1.1?

**URL:** <https://discuss.elastic.co/t/how-to-show-0-in-empty-cells-in-heatmap-in-kibana-7-1-1/193432>\
**Category:** Kibana\
**Created:** [August 2, 2019, 2:06am UTC](https://discuss.elastic.co/t/how-to-show-0-in-empty-cells-in-heatmap-in-kibana-7-1-1/193432 "2019-08-02T02:06:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![YuWatanabe](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yuwatanabe/32/13259_2.png) [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)\
**Post date:** [August 2, 2019, 2:06am UTC](https://discuss.elastic.co/t/how-to-show-0-in-empty-cells-in-heatmap-in-kibana-7-1-1/193432/1 "2019-08-02T02:06:28Z")

</div>

Hello .

I am using _heatmap visualization_ and counts that are **0\<** are showing as expected ,  
however counts that are **=0** aren't showing in cells which **0** is the value that I expect to be shown. I am using _terms aggregation_ for x and y axis. Legend displays **0 - 200** so I think **0** should be shown in the cells.

 ![heatmap](https://us1.discourse-cdn.com/elastic/original/3X/2/1/21824acd4b4f561c5743070151b491e626deb13d.png)

I read below post but solution was not provided so I decided to post my thread.

> [@Heatmap Visualisation does not show zero for empty aggregation](https://discuss.elastic.co/t/heatmap-visualisation-does-not-show-zero-for-empty-aggregation/177443):
>
> I'm building a heatmap using the Metric aggregation "Count". Sub-buckets are added: one for Date Histogram (with 1s interval) and another for Terms (hostname). I have added {"min\_doc\_count":0} for the JSON input of the Terms sub-bucke(hostname), but I am still seeing some empty buckets. I am trying to understand why not all the empty buckets are not being assigned the value of "0"...

Is there anyway to show 0 using terms aggregation ?

Thanks,  
Yu Watanabe

---

<div class="post-metadata">

**Author:** ![lukeelmers](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukeelmers/32/35230_2.png) [@lukeelmers](https://discuss.elastic.co/u/lukeelmers)\
**Post date:** [August 2, 2019, 5:12pm UTC](https://discuss.elastic.co/t/how-to-show-0-in-empty-cells-in-heatmap-in-kibana-7-1-1/193432/2 "2019-08-02T17:12:23Z")

</div>

Hi @YuWatanabe,

There isn't a way that I know of to display `0` in these cells, but it feels like something that might be useful -- perhaps you'd be willing to [open an issue](https://github.com/elastic/kibana/issues/new?template=Feature_request.md) for this on Github so we can track it there further?

---

<div class="post-metadata">

**Author:** ![YuWatanabe](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yuwatanabe/32/13259_2.png) [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)\
**Post date:** [August 6, 2019, 6:39am UTC](https://discuss.elastic.co/t/how-to-show-0-in-empty-cells-in-heatmap-in-kibana-7-1-1/193432/3 "2019-08-06T06:39:31Z")

</div>

@lukeelmers Thank you for the comment.

I have created github issue.

> <https://github.com/elastic/kibana/issues/42661>

---

<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:** [September 3, 2019, 6:39am UTC](https://discuss.elastic.co/t/how-to-show-0-in-empty-cells-in-heatmap-in-kibana-7-1-1/193432/4 "2019-09-03T06:39:32Z")

</div>

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