# How to Hide the Zero records using JSON Input in Metric Dashboard **URL:** \ **Category:** Kibana\ **Created:** [January 12, 2023, 10:29am UTC](https://discuss.elastic.co/t/how-to-hide-the-zero-records-using-json-input-in-metric-dashboard/323013 "2023-01-12T10:29:56Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Maruthappan\_Muthu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/maruthappan_muthu/32/100807_2.png) [@Maruthappan\_Muthu](https://discuss.elastic.co/u/Maruthappan_Muthu)\ **Post date:** [January 12, 2023, 10:29am UTC](https://discuss.elastic.co/t/how-to-hide-the-zero-records-using-json-input-in-metric-dashboard/323013/1 "2023-01-12T10:29:56Z")
My document gets the data on irregular interval.The field name is Ex.,SensexValue. There can be multiple values on the field (SensexValue) in every interval, with different timestamp(milliseconds) and some interval the field may not be available in the document. I am trying to calculate the sum of the field values on every interval, for that I am using SUM on Metric aggregation to add the values & using Date Histogram to bucket every minutes. Now I am getting SUM value for every interval but since some of the interval I don't have the field, I am getting 0 count. How can I hide the zero values in my dashboard.? Is it possible by using JSON Input.? ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/a/6a58d4231073263e46e792fcad01b26b35532114.png) ---
**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:** [January 12, 2023, 11:49am UTC](https://discuss.elastic.co/t/how-to-hide-the-zero-records-using-json-input-in-metric-dashboard/323013/2 "2023-01-12T11:49:53Z")
Hi @Maruthappan_Muthu what would you want to show in place of 0 values? Hide the table/row? ---
**Author:** ![Maruthappan\_Muthu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/maruthappan_muthu/32/100807_2.png) [@Maruthappan\_Muthu](https://discuss.elastic.co/u/Maruthappan_Muthu)\ **Post date:** [January 12, 2023, 11:52am UTC](https://discuss.elastic.co/t/how-to-hide-the-zero-records-using-json-input-in-metric-dashboard/323013/3 "2023-01-12T11:52:50Z")
Yes, I just want to hide the row of 0 values. ---
**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:** [January 12, 2023, 1:29pm UTC](https://discuss.elastic.co/t/how-to-hide-the-zero-records-using-json-input-in-metric-dashboard/323013/4 "2023-01-12T13:29:36Z")
No, it's not possible yet to hide rows/tables based cell values. ---
**Author:** ![Maruthappan\_Muthu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/maruthappan_muthu/32/100807_2.png) [@Maruthappan\_Muthu](https://discuss.elastic.co/u/Maruthappan_Muthu)\ **Post date:** [January 12, 2023, 1:54pm UTC](https://discuss.elastic.co/t/how-to-hide-the-zero-records-using-json-input-in-metric-dashboard/323013/5 "2023-01-12T13:54:11Z")
Okay, Is there any other option to fix the above stated case, with any type of dashboard? ---
**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:** [January 13, 2023, 10:21am UTC](https://discuss.elastic.co/t/how-to-hide-the-zero-records-using-json-input-in-metric-dashboard/323013/6 "2023-01-13T10:21:12Z")
Not yet. You can track this feature request which is asking something similar: [[Lens] Allow client-side bucket filtering of numbers by selecting the visible number range · Issue #86190 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/86190) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [February 10, 2023, 10:22am UTC](https://discuss.elastic.co/t/how-to-hide-the-zero-records-using-json-input-in-metric-dashboard/323013/7 "2023-02-10T10:22:04Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.