# How to show zero value in len **URL:** \ **Category:** Kibana\ **Tags:** lens\ **Created:** [May 16, 2023, 3:07am UTC](https://discuss.elastic.co/t/how-to-show-zero-value-in-len/333517 "2023-05-16T03:07:14Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![tonyaw](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tonyaw/32/120151_2.png) [@tonyaw](https://discuss.elastic.co/u/tonyaw)\ **Post date:** [May 16, 2023, 3:07am UTC](https://discuss.elastic.co/t/how-to-show-zero-value-in-len/333517/1 "2023-05-16T03:07:14Z")
I had a search result which has non-zero per 2 hours. I want to use Lens to show a sawtooth graph per hour(contains both non-zero value and zero value). May I ask how to configure it? Currently, I got a straight line result: ![kibana_issue](https://us1.discourse-cdn.com/elastic/original/3X/c/d/cdf97d87343fbd803aee165000ed969027c353b7.png) My queried data: ![kibana_issue](https://us1.discourse-cdn.com/elastic/original/3X/d/2/d209c840c9238a803fca54e11eecd77a83c998a6.png) Please note that I must use "Top values" instead of "Intervals" for breakdown configuration. Otherwise, I will get another error: > [@Kibana dashboard filter doesn't work](https://discuss.elastic.co/t/kibana-dashboard-filter-doesnt-work/330675/11): > > Thanks for your reminder. Following is the root cause. I used "Intervals" instead of "Top values" wrongly. After change it back to "Top values", Filter works fine. Thanks for your great support! slight_smile [kibana\_issue] ![kibana_issue](https://us1.discourse-cdn.com/elastic/original/3X/4/3/43bc0b37da41b6967ad5378f05f03cf17033ea75.png) Thanks in advance! ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [May 16, 2023, 10:23am UTC](https://discuss.elastic.co/t/how-to-show-zero-value-in-len/333517/2 "2023-05-16T10:23:06Z")
Hi @tonyaw One thing you can do is to configure a `Missing value` (from the `Visual options` popover) to use the `Zero` option, and enforce a 1h date histogram interval. ---
**Author:** ![tonyaw](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tonyaw/32/120151_2.png) [@tonyaw](https://discuss.elastic.co/u/tonyaw)\ **Post date:** [May 16, 2023, 2:11pm UTC](https://discuss.elastic.co/t/how-to-show-zero-value-in-len/333517/3 "2023-05-16T14:11:48Z")
Thanks for your reply. Actually, I have tried, but nothing is changed: ![kibana_issue](https://us1.discourse-cdn.com/elastic/original/3X/3/0/304468e82a52b4fe9b54d1aba5632043eca617bf.png) Shall I must force the time to be 1h? Could you please help to check if anything is missed? ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [May 16, 2023, 3:59pm UTC](https://discuss.elastic.co/t/how-to-show-zero-value-in-len/333517/4 "2023-05-16T15:59:10Z")
Have you configured a minimum interval in the `Date histogram` dimension? ![Screenshot 2023-05-16 at 17.58.47](https://us1.discourse-cdn.com/elastic/original/3X/5/1/51c2f6ec6e96fae412eef5c5f523262e5f72cb8a.png) ---
**Author:** ![tonyaw](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tonyaw/32/120151_2.png) [@tonyaw](https://discuss.elastic.co/u/tonyaw)\ **Post date:** [May 17, 2023, 9:21am UTC](https://discuss.elastic.co/t/how-to-show-zero-value-in-len/333517/5 "2023-05-17T09:21:33Z")
![kibana_issue](https://us1.discourse-cdn.com/elastic/original/3X/b/9/b91fbbda9aa68d39c6c10ebf918095207d3112e0.png) No change. BTW. the original value is "Auto(1h)" ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 14, 2023, 9:22am UTC](https://discuss.elastic.co/t/how-to-show-zero-value-in-len/333517/6 "2023-06-14T09:22:16Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.