# How to hide rows in table without affecting search criteria

**URL:** https://discuss.elastic.co/t/how-to-hide-rows-in-table-without-affecting-search-criteria/329033
**Category:** Kibana
**Created:** [March 31, 2023, 9:22am UTC](https://discuss.elastic.co/t/how-to-hide-rows-in-table-without-affecting-search-criteria/329033 "2023-03-31T09:22:29Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![abhardwaj](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@abhardwaj](https://discuss.elastic.co/u/abhardwaj)
#### Post date: [March 31, 2023, 9:22am UTC](https://discuss.elastic.co/t/how-to-hide-rows-in-table-without-affecting-search-criteria/329033/1 "2023-03-31T09:22:29Z")

</div>

Hello,

I am creating a kibana visualization table based on few test run results in my elasticsearch index.  
Following is the composition of value hits.

 ![index_data](https://us1.discourse-cdn.com/elastic/original/3X/4/5/459879db506cb71ab0ff23cf054bd848aed320c5.png)

Following is the output table having the results captured

 ![kibana_table](https://us1.discourse-cdn.com/elastic/original/3X/5/1/51ef64a9206559720a6ad8d6a5159128e171d153.png)

The filters in table i've applied based on Result & Accuracy columns. What i want to do is only show the coloumns which shows average 100% accuracy.  
I've tried filtering out the fail results but that removes them from calculation and shows everything as 100% since only pass results comes into calculation.

Is there a way to achieve this with current data ?

Thanks

Reference Calculations:  
Columns:

1. Pass Accuracy --\> Average of Accuracy Column in index with value format as Percent.
2. Fail Runs --\> Count of Records with filter by "Result = Fail".
3. Pass Runs --\> Count of Records with filter by "Result = Pass".
4. Total Runs --\> Count of Records.  
Rows:
5. Test Name --\> Top Values of Test Name
6. Test Suite --\> Top Values of Test Suite

---

<div class="post-metadata">

### Author: ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)
#### Post date: [March 31, 2023, 9:28am UTC](https://discuss.elastic.co/t/how-to-hide-rows-in-table-without-affecting-search-criteria/329033/2 "2023-03-31T09:28:45Z")

</div>

So if I understand correctly you would like to hide specific rows. I am afraid that this is not possible atm.

If you want to hide columns we have this hide column setting that you can use

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

---

<div class="post-metadata">

### Author: ![abhardwaj](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@abhardwaj](https://discuss.elastic.co/u/abhardwaj)
#### Post date: [March 31, 2023, 9:33am UTC](https://discuss.elastic.co/t/how-to-hide-rows-in-table-without-affecting-search-criteria/329033/3 "2023-03-31T09:33:17Z")

</div>

> [@Stratoula\_Kalafateli](#):
>
> If you want to hide columns we have this hide column setting that you can use

Yes i want to hide certain rows but based on a specific logic.  
Like all the rows should not be visible where the "Fail Runs" is not 0 or if the "Pass Runs" is less than "Total Runs".

But i'm not able to find a filter for such comparision.

Additionally, what i already tried is applying a filter for my condition like "Result = Pass" but in that case the fail values gets removed from the total calculation and all 5 rows return 100% which is incorrect interpretation of data.

---

<div class="post-metadata">

### Author: ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)
#### Post date: [March 31, 2023, 9:34am UTC](https://discuss.elastic.co/t/how-to-hide-rows-in-table-without-affecting-search-criteria/329033/4 "2023-03-31T09:34:49Z")

</div>

Got it, no I am afraid this is not possible atm. You can always create an enhancement request on our public repo and the team can assess and prioritize.

---

<div class="post-metadata">

### Author: ![abhardwaj](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@abhardwaj](https://discuss.elastic.co/u/abhardwaj)
#### Post date: [March 31, 2023, 9:35am UTC](https://discuss.elastic.co/t/how-to-hide-rows-in-table-without-affecting-search-criteria/329033/5 "2023-03-31T09:35:36Z")

</div>

Alright, thanks for the reply.

---

<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: [April 28, 2023, 9:36am UTC](https://discuss.elastic.co/t/how-to-hide-rows-in-table-without-affecting-search-criteria/329033/6 "2023-04-28T09:36:35Z")

</div>

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