# Heatmap is hiding empty rows **URL:** \ **Category:** Kibana\ **Created:** [May 13, 2021, 5:13pm UTC](https://discuss.elastic.co/t/heatmap-is-hiding-empty-rows/272938 "2021-05-13T17:13:08Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![gelfert](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gelfert/32/88721_2.png) [@gelfert](https://discuss.elastic.co/u/gelfert)\ **Post date:** [May 13, 2021, 5:13pm UTC](https://discuss.elastic.co/t/heatmap-is-hiding-empty-rows/272938/1 "2021-05-13T17:13:08Z")
I am trying to create a heatmap on a numeric field over some time period, using the aggregation based tool. After selecting "Value: count", I create the y-axis histogram. I select "show empty buckets" and I get a bunch of evenly spaced rows, including empty rows. But then when I add the x-axis date histogram, the empty y-axis buckets disappear and the first row jumps from 0 to 40 (the max is 100), so the scale looks skewed. Is this a bug, or am I doing something wrong? ---
**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\ **Post date:** [May 13, 2021, 9:23pm UTC](https://discuss.elastic.co/t/heatmap-is-hiding-empty-rows/272938/2 "2021-05-13T21:23:03Z")
Hi Galen, I'm not able to recreate the issue on my end. But I might also need more context. Can you share screenshots showing the skewed chart? ---
**Author:** ![gelfert](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gelfert/32/88721_2.png) [@gelfert](https://discuss.elastic.co/u/gelfert)\ **Post date:** [May 13, 2021, 11:09pm UTC](https://discuss.elastic.co/t/heatmap-is-hiding-empty-rows/272938/3 "2021-05-13T23:09:53Z")
Yes, absolutely. Here is the initial y-axis histogram: ![kibana-heat01](https://us1.discourse-cdn.com/elastic/original/3X/d/1/d13c1d9bf7cede04c81ea1a9b6b394a36913a334.png) Here it is with "Show empty buckets": ![kibana-heat02](https://us1.discourse-cdn.com/elastic/original/3X/9/5/95e2b1acb362cbe3afc5ed3c35a5e9564d30bead.png) And here is what happens when I add the x-axis date histogram. The empty y-axis buckets disappear again: ![kibana-heat03](https://us1.discourse-cdn.com/elastic/original/3X/8/9/89b52c060a9129757207d0e459a408574bf4a944.png) I also found something else strange. If I create the x-axis first, and then the y-axis, the y-axis ordering is all weird. At first it looks random, but it actually appears to be ordered according to the order in which the earliest event in each bucket occurs: ![kibana-heat04](https://us1.discourse-cdn.com/elastic/original/3X/b/0/b06bb07d8ea4d5e5b2f499b68b38921ebc8c5669.png) ---
**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\ **Post date:** [May 18, 2021, 9:31pm UTC](https://discuss.elastic.co/t/heatmap-is-hiding-empty-rows/272938/4 "2021-05-18T21:31:29Z")
Thanks Galen. I'm able to recreate the issue with the empty buckets now. [Here is the bug report](https://github.com/elastic/kibana/issues/100301). I was able to work around this issue by moving the x-axis on top of the y-axis (click and drag the two bars next to the red x) and specifying the min and max with Extend bounds toggled on. But this requires knowing the bounds, so it's not a perfect workaround. ---
**Author:** ![gelfert](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gelfert/32/88721_2.png) [@gelfert](https://discuss.elastic.co/u/gelfert)\ **Post date:** [May 21, 2021, 10:59pm UTC](https://discuss.elastic.co/t/heatmap-is-hiding-empty-rows/272938/5 "2021-05-21T22:59:48Z")
That's great, thanks. I was able to use the work around in this particular case, since the data has fixed bounds. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 18, 2021, 11:00pm UTC](https://discuss.elastic.co/t/heatmap-is-hiding-empty-rows/272938/6 "2021-06-18T23:00:10Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.