# Count a specific value of a field as metric

**URL:** <https://discuss.elastic.co/t/count-a-specific-value-of-a-field-as-metric/119718>\
**Category:** Kibana\
**Created:** [February 14, 2018, 2:58am UTC](https://discuss.elastic.co/t/count-a-specific-value-of-a-field-as-metric/119718 "2018-02-14T02:58:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Diego\_Nogueira](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_nogueira/32/27750_2.png) [@Diego\_Nogueira](https://discuss.elastic.co/u/Diego_Nogueira)\
**Post date:** [February 14, 2018, 2:58am UTC](https://discuss.elastic.co/t/count-a-specific-value-of-a-field-as-metric/119718/1 "2018-02-14T02:58:53Z")

</div>

hi everyone, i'm trying count a specific value of a field, as a metric at data table visualization, but i don't known as do it. Could anyone help? Thanks.

---

<div class="post-metadata">

**Author:** ![spalger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spalger/32/14092_2.png) [@spalger](https://discuss.elastic.co/u/spalger)\
**Post date:** [February 14, 2018, 3:45pm UTC](https://discuss.elastic.co/t/count-a-specific-value-of-a-field-as-metric/119718/2 "2018-02-14T15:45:27Z")

</div>

Do you want to count the number of times a field has a specific value? Or add up the values of a field?

Assuming you want to count the number of times a field has a specific value, then you want your metric to be "Count" and you want to "Split Rows" in the data table on "Filters", then in the filter box type `field:value`, replacing `field` with the field name you want, and `value` with the value you want to filter by (make sure there is no space between the field and value, only a `:`)

---

<div class="post-metadata">

**Author:** ![Diego\_Nogueira](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_nogueira/32/27750_2.png) [@Diego\_Nogueira](https://discuss.elastic.co/u/Diego_Nogueira)\
**Post date:** [February 14, 2018, 11:00pm UTC](https://discuss.elastic.co/t/count-a-specific-value-of-a-field-as-metric/119718/3 "2018-02-14T23:00:49Z")

</div>

Yes, I want count a specific value. Thanks for reply :). Is there any way to do this without using filters? Why I want to create a column with each specific count.

If i use filters and always applyed a other filter, the values reduce on 0, for example (table exemplo that I need):

Country Reject\_Connect Reject\_Blacklist  
BRAZIL 200,000 50  
USA 100,000 30  
AGENTINA 50,000 40

it's posible?  
Thanks a lot.

---

<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:** [March 14, 2018, 11:00pm UTC](https://discuss.elastic.co/t/count-a-specific-value-of-a-field-as-metric/119718/4 "2018-03-14T23:00:56Z")

</div>

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