# Only show filters which have a value in metrics

**URL:** https://discuss.elastic.co/t/only-show-filters-which-have-a-value-in-metrics/41605
**Category:** Kibana
**Created:** [February 12, 2016, 11:40am UTC](https://discuss.elastic.co/t/only-show-filters-which-have-a-value-in-metrics/41605 "2016-02-12T11:40:12Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![isaacpm](https://avatars.discourse-cdn.com/v4/letter/i/b9e5f3/32.png) [@isaacpm](https://discuss.elastic.co/u/isaacpm)
#### Post date: [February 12, 2016, 11:40am UTC](https://discuss.elastic.co/t/only-show-filters-which-have-a-value-in-metrics/41605/1 "2016-02-12T11:40:12Z")

</div>

Hi,

I'm building a table visualization in kibana 4.4 that has many filters to tag the different entries.  
It has three max metrics.  
It works well except for the fact that rows with empty metrics also show.  
Is there a way to make it show only rows with values in the metrics?

Thanks,  
Isaac

---

<div class="post-metadata">

### Author: ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [February 19, 2016, 2:35pm UTC](https://discuss.elastic.co/t/only-show-filters-which-have-a-value-in-metrics/41605/2 "2016-02-19T14:35:02Z")

</div>

Not that I know of. Have you seen other products do that? I'd be curious what the configuration looked like for that kind of conditional display.

---

<div class="post-metadata">

### Author: ![isaacpm](https://avatars.discourse-cdn.com/v4/letter/i/b9e5f3/32.png) [@isaacpm](https://discuss.elastic.co/u/isaacpm)
#### Post date: [February 19, 2016, 3:14pm UTC](https://discuss.elastic.co/t/only-show-filters-which-have-a-value-in-metrics/41605/3 "2016-02-19T15:14:06Z")

</div>

I don't know of any, I only use Kibana at the moment.

I will try with the bucket aggregation and script filtering, it may do the trick.

---

<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: [July 6, 2017, 2:01pm UTC](https://discuss.elastic.co/t/only-show-filters-which-have-a-value-in-metrics/41605/4 "2017-07-06T14:01:37Z")

</div>


