# Kibana \> Visualize \> Data Table \> Metric Count \> How to set Range for the Counted value?

**URL:** <https://discuss.elastic.co/t/kibana-visualize-data-table-metric-count-how-to-set-range-for-the-counted-value/249597>\
**Category:** Kibana\
**Created:** [September 23, 2020, 1:17am UTC](https://discuss.elastic.co/t/kibana-visualize-data-table-metric-count-how-to-set-range-for-the-counted-value/249597 "2020-09-23T01:17:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andreasau](https://avatars.discourse-cdn.com/v4/letter/a/9e8a1a/32.png) [@Andreasau](https://discuss.elastic.co/u/Andreasau)\
**Post date:** [September 23, 2020, 1:17am UTC](https://discuss.elastic.co/t/kibana-visualize-data-table-metric-count-how-to-set-range-for-the-counted-value/249597/1 "2020-09-23T01:17:38Z")

</div>

Good day All,

Can anyone kindly teach me how to set Range for the Counted value in the Data Table (Visualize)?

Real situation:  
I created a Table which shown the stock level for each product in each shop location,  
I would like to filter out the shop which keep more than 10 stock on each specific product  
(In order words, i would like to filter out "count" \> 10)

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/c/cc2df4110dbe9de7105078592d6ec14f931424e7.png)

Thank you  
Andreas

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [September 24, 2020, 7:10pm UTC](https://discuss.elastic.co/t/kibana-visualize-data-table-metric-count-how-to-set-range-for-the-counted-value/249597/2 "2020-09-24T19:10:13Z")

</div>

Hello, can you please try using advanced JSON input field? You can add your limitation there and it should help you get your datatable with "count" \< 10

Here is a screenshot to show you where is it -

 ![Screen Shot 2020-09-24 at 3.06.34 PM](https://us1.discourse-cdn.com/elastic/original/3X/6/0/60790fe059ec65e68e11c4e73e6d44596d77e471.jpeg)

Thanks  
Bhavya

---

<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:** [October 22, 2020, 7:10pm UTC](https://discuss.elastic.co/t/kibana-visualize-data-table-metric-count-how-to-set-range-for-the-counted-value/249597/3 "2020-10-22T19:10:15Z")

</div>

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