# Applying filters on a metric using Visual Builder

**URL:** <https://discuss.elastic.co/t/applying-filters-on-a-metric-using-visual-builder/129026>\
**Category:** Kibana\
**Created:** [April 23, 2018, 12:35am UTC](https://discuss.elastic.co/t/applying-filters-on-a-metric-using-visual-builder/129026 "2018-04-23T00:35:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kenneth](https://avatars.discourse-cdn.com/v4/letter/k/94ad74/32.png) [@kenneth](https://discuss.elastic.co/u/kenneth)\
**Post date:** [April 23, 2018, 12:35am UTC](https://discuss.elastic.co/t/applying-filters-on-a-metric-using-visual-builder/129026/1 "2018-04-23T00:35:58Z")

</div>

Hi,

Is it possible to apply a filter on a metric aggregation in Kibana using the data set below?

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

I would like to report on

- Count (10)
- Average (30.43) - which is the sum of the ages divided by 7 (i.e. excluding the empty/zero age attributes).

Is there anyway to provide the filters in the settings?

![image](https://us1.discourse-cdn.com/elastic/original/3X/3/a/3a54d6d85e3a8b83b07045b5d8e50e341671bc1d.jpg)

Regards  
Kenneth

---

<div class="post-metadata">

**Author:** ![chrisronline](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chrisronline/32/28230_2.png) [@chrisronline](https://discuss.elastic.co/u/chrisronline)\
**Post date:** [April 23, 2018, 3:33pm UTC](https://discuss.elastic.co/t/applying-filters-on-a-metric-using-visual-builder/129026/2 "2018-04-23T15:33:06Z")

</div>

Hey @kenneth,

You should be able to apply a filter at the top for something like this.

 ![12%20AM](https://us1.discourse-cdn.com/elastic/original/3X/d/3/d30b9de2410c4b98e04851229df0ab99947df927.png)

Let me know if that helps,

Thanks,  
Chris

---

<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:** [May 21, 2018, 3:33pm UTC](https://discuss.elastic.co/t/applying-filters-on-a-metric-using-visual-builder/129026/3 "2018-05-21T15:33:24Z")

</div>

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