# How to hide count in Data Table?

**URL:** https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274
**Category:** Kibana
**Created:** [December 29, 2019, 6:44am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274 "2019-12-29T06:44:11Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![volcano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/volcano/32/46287_2.png) [@volcano](https://discuss.elastic.co/u/volcano)
#### Post date: [December 29, 2019, 6:44am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/1 "2019-12-29T06:44:11Z")

</div>

I'm displaying a Data Table. I dont want to display default Count metric.

How to hide it ?

looking for an easy fix ?

![](https://us1.discourse-cdn.com/elastic/original/3X/a/7/a7630c1dc9ae2067467f3ee5485d5b0153643691.png)

---

<div class="post-metadata">

### Author: ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [December 30, 2019, 9:18am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/2 "2019-12-30T09:18:15Z")

</div>

Hi @volcano, are you trying to display individual documents or aggregates of documents? If you just want to show the values of two fields for each document, you can use a [saved search](https://www.elastic.co/guide/en/kibana/current/save-open-search.html) - just go to discover, select the fields you want and click save in the menu on the top. Then you can add the current view to a dashboard.

---

<div class="post-metadata">

### Author: ![volcano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/volcano/32/46287_2.png) [@volcano](https://discuss.elastic.co/u/volcano)
#### Post date: [December 30, 2019, 10:51am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/3 "2019-12-30T10:51:19Z")

</div>

> [@flash1293](#):
>
> select the fields you want and click save in the menu on the top.

I did this .....in this approach , there is one issue.....if the selected fields dont have any data , it shows blank rows in Data Table.

I dont want to show blank rows in my Data Table.

Example:  
 ![](https://us1.discourse-cdn.com/elastic/original/3X/f/9/f983f341b008df935c84bc03bb4506d56f57661c.png)

---

<div class="post-metadata">

### Author: ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [December 30, 2019, 11:00am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/4 "2019-12-30T11:00:31Z")

</div>

If you want to exclude these rows, you can add a filter to the saved search (it will be saved along with the selected fields and also applied when the search is embedded on a dashboard):

 ![Screenshot 2019-12-30 at 11.58.24](https://us1.discourse-cdn.com/elastic/original/3X/0/b/0bb3497cdac2c3008e4d316bb8e277e5f99950f2.png)

If your documents contain a dash character instead of omitting the field, you can also add an `is not` filter.

---

<div class="post-metadata">

### Author: ![volcano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/volcano/32/46287_2.png) [@volcano](https://discuss.elastic.co/u/volcano)
#### Post date: [December 30, 2019, 11:09am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/5 "2019-12-30T11:09:35Z")

</div>

Yes. Filter is working fine.

After applying filter I get this :

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

But I did not select any **Time** field. It has come to this table by default. How do I get rid of this **Time** field ?

---

<div class="post-metadata">

### Author: ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [December 30, 2019, 11:27am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/6 "2019-12-30T11:27:20Z")

</div>

You can do this via the advanced setting `doc_table:hideTimeColumn`. This will hide the time column for all saved searches. If you want to add them back in some cases, you can manually select your time field and it will add a regular column.

---

<div class="post-metadata">

### Author: ![volcano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/volcano/32/46287_2.png) [@volcano](https://discuss.elastic.co/u/volcano)
#### Post date: [December 30, 2019, 11:48am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/7 "2019-12-30T11:48:33Z")

</div>

> [@flash1293](#):
>
> hideTimeColumn

awesome. ..... advanced settings worked !

![](https://us1.discourse-cdn.com/elastic/original/3X/5/9/59a921453afc409511342ddd687c7f2d59e5d3b4.png)

Only one issue is here ..... I dont want to display column names as **partB , partD**.

I want to customize it to some meaningful name.

can I rename it ?

I want to rename **partB** to **request\_time** and **partD** to **response\_time**.

How to do this ?

---

<div class="post-metadata">

### Author: ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [December 30, 2019, 1:03pm UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/8 "2019-12-30T13:03:17Z")

</div>

That's not possible at the moment without re-ingesting your documents and renaming (or copying) the fields in the source. You can do this with the `copy_to` parameter in the mapping: [https://www.elastic.co/guide/en/elasticsearch/reference/current/copy-to.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/copy-to.html)

Create a new index with the mapping containing `copty_to` and then use the [re-index](https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-reindex.html) to ingest the documents again.

This issue tracks progress on adding the functionality in Kibana itself: [https://github.com/elastic/kibana/issues/47659](https://github.com/elastic/kibana/issues/47659)

---

<div class="post-metadata">

### Author: ![balaji\_18](https://avatars.discourse-cdn.com/v4/letter/b/bbce88/32.png) [@balaji\_18](https://discuss.elastic.co/u/balaji_18)
#### Post date: [January 8, 2020, 7:30am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/9 "2020-01-08T07:30:34Z")

</div>

Install Enhanced table plugin- using this plugin we can hide columns.

---

<div class="post-metadata">

### Author: ![volcano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/volcano/32/46287_2.png) [@volcano](https://discuss.elastic.co/u/volcano)
#### Post date: [January 8, 2020, 7:33am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/10 "2020-01-08T07:33:21Z")

</div>

How to install this plugin ?

---

<div class="post-metadata">

### Author: ![balaji\_18](https://avatars.discourse-cdn.com/v4/letter/b/bbce88/32.png) [@balaji\_18](https://discuss.elastic.co/u/balaji_18)
#### Post date: [January 8, 2020, 7:34am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/11 "2020-01-08T07:34:35Z")

</div>

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

---

<div class="post-metadata">

### Author: ![balaji\_18](https://avatars.discourse-cdn.com/v4/letter/b/bbce88/32.png) [@balaji\_18](https://discuss.elastic.co/u/balaji_18)
#### Post date: [January 8, 2020, 7:35am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/12 "2020-01-08T07:35:49Z")

</div>

Download this plugin using this link : [https://github.com/fbaligand/kibana-enhanced-table/releases](https://github.com/fbaligand/kibana-enhanced-table/releases)  
and follow the steps

---

<div class="post-metadata">

### Author: ![balaji\_18](https://avatars.discourse-cdn.com/v4/letter/b/bbce88/32.png) [@balaji\_18](https://discuss.elastic.co/u/balaji_18)
#### Post date: [January 8, 2020, 7:36am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/13 "2020-01-08T07:36:31Z")

</div>

Every release package includes a Plugin version (X.Y.Z) and a Kibana version (A.B.C).

- Go to [releases](https://github.com/fbaligand/kibana-enhanced-table/releases) and choose the right one for your Kibana
- launch a shell terminal and go to $KIBANA\_HOME/bin folder
- use Kibana CLI to install :
  - directly from Internet URL : `$KIBANA_HOME/bin/kibana-plugin install https://github.com/fbaligand/kibana-enhanced-table/releases/download/vX.Y.Z/enhanced-table-X.Y.Z_A.B.C.zip`
  - locally after manual download : `$KIBANA_HOME/bin/kibana-plugin install file:///path/to/enhanced-table-X.Y.Z_A.B.C.zip`

- restart Kibana

---

<div class="post-metadata">

### Author: ![volcano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/volcano/32/46287_2.png) [@volcano](https://discuss.elastic.co/u/volcano)
#### Post date: [January 8, 2020, 9:01am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/14 "2020-01-08T09:01:23Z")

</div>

> [@balaji\_18](#):
>
> use Kibana CLI to install :

I dont have access to CLI.  
I am using managed service.  
I have only access to Kibana UI.

Can it be installed from Kibana UI ?

---

<div class="post-metadata">

### Author: ![balaji\_18](https://avatars.discourse-cdn.com/v4/letter/b/bbce88/32.png) [@balaji\_18](https://discuss.elastic.co/u/balaji_18)
#### Post date: [January 8, 2020, 9:02am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/15 "2020-01-08T09:02:49Z")

</div>

yes, just use that commands in cmd

---

<div class="post-metadata">

### Author: ![volcano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/volcano/32/46287_2.png) [@volcano](https://discuss.elastic.co/u/volcano)
#### Post date: [January 8, 2020, 9:04am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/16 "2020-01-08T09:04:52Z")

</div>

> [@balaji\_18](#):
>
> yes, just use that commands in cmd

You did not get me. I am saying , I dont have cmd or CLI access. I have Kibana UI access.

Can it be installed from Kibana UI ?

---

<div class="post-metadata">

### Author: ![balaji\_18](https://avatars.discourse-cdn.com/v4/letter/b/bbce88/32.png) [@balaji\_18](https://discuss.elastic.co/u/balaji_18)
#### Post date: [January 8, 2020, 9:06am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/17 "2020-01-08T09:06:14Z")

</div>

ELK is not in your system ?

---

<div class="post-metadata">

### Author: ![balaji\_18](https://avatars.discourse-cdn.com/v4/letter/b/bbce88/32.png) [@balaji\_18](https://discuss.elastic.co/u/balaji_18)
#### Post date: [January 8, 2020, 9:18am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/18 "2020-01-08T09:18:36Z")

</div>

No, u can't from kibana UI

---

<div class="post-metadata">

### Author: ![volcano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/volcano/32/46287_2.png) [@volcano](https://discuss.elastic.co/u/volcano)
#### Post date: [January 8, 2020, 10:31am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/19 "2020-01-08T10:31:17Z")

</div>

I am using AWS ELK. This is managed service. I can not log into Kibana instance.

---

<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: [February 5, 2020, 10:41am UTC](https://discuss.elastic.co/t/how-to-hide-count-in-data-table/213274/20 "2020-02-05T10:41:52Z")

</div>

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