# Only show higher values than X

**URL:** <https://discuss.elastic.co/t/only-show-higher-values-than-x/170044>\
**Category:** Kibana\
**Created:** [February 26, 2019, 4:21pm UTC](https://discuss.elastic.co/t/only-show-higher-values-than-x/170044 "2019-02-26T16:21:38Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![jtebbens](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jtebbens](https://discuss.elastic.co/u/jtebbens)\
**Post date:** [February 26, 2019, 4:21pm UTC](https://discuss.elastic.co/t/only-show-higher-values-than-x/170044/1 "2019-02-26T16:21:38Z")

</div>

Hi all,

Show example I have some aggregation result of X but need to only show anything above 98, how can I do this?

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

---

<div class="post-metadata">

**Author:** ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)\
**Post date:** [February 27, 2019, 2:36pm UTC](https://discuss.elastic.co/t/only-show-higher-values-than-x/170044/2 "2019-02-27T14:36:38Z")

</div>

hi @jtebbens, this isn't possible right now, but a request of this improvement has already been logged [https://github.com/elastic/kibana/issues/17544](https://github.com/elastic/kibana/issues/17544), and specifically for data tables [https://github.com/elastic/kibana/issues/11167](https://github.com/elastic/kibana/issues/11167)

This would require Kibana to support the bucket selector aggregation from Elasticsearch ([https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-bucket-selector-aggregation.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-bucket-selector-aggregation.html))

---

<div class="post-metadata">

**Author:** ![jtebbens](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jtebbens](https://discuss.elastic.co/u/jtebbens)\
**Post date:** [February 27, 2019, 9:23pm UTC](https://discuss.elastic.co/t/only-show-higher-values-than-x/170044/3 "2019-02-27T21:23:58Z")

</div>

You recon this plugin might help or not worth trying?

> **[fbaligand/kibana-enhanced-table](https://github.com/fbaligand/kibana-enhanced-table)**
>
> Kibana visualization like a Data Table, but with enhanced features like computed columns and filter bar - fbaligand/kibana-enhanced-table

---

<div class="post-metadata">

**Author:** ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)\
**Post date:** [February 28, 2019, 1:35am UTC](https://discuss.elastic.co/t/only-show-higher-values-than-x/170044/4 "2019-02-28T01:35:39Z")

</div>

yes, I think that plugin would work

---

<div class="post-metadata">

**Author:** ![fbaligand](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fbaligand/32/5657_2.png) [@fbaligand](https://discuss.elastic.co/u/fbaligand)\
**Post date:** [February 28, 2019, 6:25am UTC](https://discuss.elastic.co/t/only-show-higher-values-than-x/170044/5 "2019-02-28T06:25:54Z")

</div>

So if I understand we’ll, you want to show only tables lines where max value is greater than 98 ?  
If so, I don’t think that enhanced table could fix this need.  
But probably datasweet formula plugin should fix your need.

---

<div class="post-metadata">

**Author:** ![jtebbens](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jtebbens](https://discuss.elastic.co/u/jtebbens)\
**Post date:** [February 28, 2019, 7:24am UTC](https://discuss.elastic.co/t/only-show-higher-values-than-x/170044/6 "2019-02-28T07:24:35Z")

</div>

Thanks @fbaligand for your response. One need is indeed to show only the 98% and above to list (filters in the table is max per device/interface) problem is it will show all the max values but I want to limit onlythe 98% and up values there. Another table I have is looking at count=0 or less than 10 results.

Your plug would at least assist me on hiding that count results. Which I only want to list the fields but not show the count or value results and hide it.

One side effect I notice from your plugin I try to test is that it seems to only show the enhanced table in the visual list on Safari/Ipad but not on Firefox or Chrome when I browse to Kibana. Not sure if you are aware of this. ELK version used currently is 6.5.1

---

<div class="post-metadata">

**Author:** ![fbaligand](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fbaligand/32/5657_2.png) [@fbaligand](https://discuss.elastic.co/u/fbaligand)\
**Post date:** [February 28, 2019, 10:41am UTC](https://discuss.elastic.co/t/only-show-higher-values-than-x/170044/7 "2019-02-28T10:41:26Z")

</div>

Well, happy if enhanced-table could help you for some use case!  
For your " Only show higher values than X" need, I plan to add a new feature "Lines computed filter" that would answer that need.  
In this editor setting, you can set an "expr-eval" formula using column values to say if line is displayed or not. Example: "col3 \>= 98"

But for now, such a feature is not available.  
Filter Bar is a "full text search" feature for dashboard viewers to find particular table lines at "view time".

Concerning bug on Chrome and Firefox, I'm very surprised. I personally use the plugin on Chrome and Firefox and have no bug.  
I invite you to open an issue on github with all details to reproduce your issue.

---

<div class="post-metadata">

**Author:** ![jtebbens](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jtebbens](https://discuss.elastic.co/u/jtebbens)\
**Post date:** [February 28, 2019, 12:18pm UTC](https://discuss.elastic.co/t/only-show-higher-values-than-x/170044/8 "2019-02-28T12:18:52Z")

</div>

Regarding browser issue I only notice it takes a long time to install plugin

Attempting to transfer from [https://github.com/fbaligand/kibana-enhanced-table/releases/download/v1.0.0/enhanced-table-1.0.0\_6.5.1.zip](https://github.com/fbaligand/kibana-enhanced-table/releases/download/v1.0.0/enhanced-table-1.0.0_6.5.1.zip)  
Transferring 38208 bytes....................  
Transfer complete  
Retrieving metadata from plugin archive  
Extracting plugin archive  
Extraction complete  
Optimizing and caching browser bundles...

And kibana status shows  
Browserslist: caniuse-lite is outdated. Please run next command `npm update caniuse-lite browserslist`

---

<div class="post-metadata">

**Author:** ![jtebbens](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jtebbens](https://discuss.elastic.co/u/jtebbens)\
**Post date:** [February 28, 2019, 12:36pm UTC](https://discuss.elastic.co/t/only-show-higher-values-than-x/170044/9 "2019-02-28T12:36:27Z")

</div>

I checked the datasweet plugin but that seem to had no update as per 6.4.2 so not really able to try that.

---

<div class="post-metadata">

**Author:** ![jtebbens](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jtebbens](https://discuss.elastic.co/u/jtebbens)\
**Post date:** [February 28, 2019, 2:25pm UTC](https://discuss.elastic.co/t/only-show-higher-values-than-x/170044/10 "2019-02-28T14:25:49Z")

</div>

I reinstalled your plugin @fbaligand again and it works now for all browsers. Funny enough it resolved by itself. Testing my theory on the tables.

---

<div class="post-metadata">

**Author:** ![fbaligand](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fbaligand/32/5657_2.png) [@fbaligand](https://discuss.elastic.co/u/fbaligand)\
**Post date:** [February 28, 2019, 6:12pm UTC](https://discuss.elastic.co/t/only-show-higher-values-than-x/170044/11 "2019-02-28T18:12:32Z")

</div>

Well, every plugin is long to install, because the whole "optimized" folder is rebuilt (for all Kibana code).  
The mentioned warning concerns Kibana core.

Concerning datasweet plugin, I know it does not provide releases for Kibana versions \> 6.4. That's sad, but in the following comment, it explains how to build a version compatible withe Kibana 6.5:

> <https://github.com/datasweet/kibana-datasweet-formula/issues/34#issuecomment-458857713>

Concerning enhanced-table plugin, enjoy it!  
When I'll release enhanced-table plugin with "Lines computed filter" feature, I will notify here.

By the way, if someone has a better feature name, don't hesitate to tell me 🙂

---

<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 28, 2019, 6:12pm UTC](https://discuss.elastic.co/t/only-show-higher-values-than-x/170044/12 "2019-03-28T18:12:32Z")

</div>

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