# How to stack Bucket level column in Data Table Visualization of Kibana

**URL:** https://discuss.elastic.co/t/how-to-stack-bucket-level-column-in-data-table-visualization-of-kibana/145318
**Category:** Kibana
**Created:** [August 21, 2018, 7:46am UTC](https://discuss.elastic.co/t/how-to-stack-bucket-level-column-in-data-table-visualization-of-kibana/145318 "2018-08-21T07:46:12Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![groverjatin17](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/groverjatin17/32/34657_2.png) [@groverjatin17](https://discuss.elastic.co/u/groverjatin17)
#### Post date: [August 21, 2018, 7:46am UTC](https://discuss.elastic.co/t/how-to-stack-bucket-level-column-in-data-table-visualization-of-kibana/145318/1 "2018-08-21T07:46:12Z")

</div>

Hi i have created this table wtih dummy data i had.

 ![Untitled](https://us1.discourse-cdn.com/elastic/original/3X/1/6/169ff9cb587ac945127c83e28268400a9a9dc8a1.png)

I want the Column1 and Column2 stacked in the left most end like in the Normal Excel table  
and then the countries and their values in rest of the fields.

The re-printing of the buckets columns makes the table very cluttersome. Please suggest a solution.

---

<div class="post-metadata">

### Author: ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [August 21, 2018, 9:01pm UTC](https://discuss.elastic.co/t/how-to-stack-bucket-level-column-in-data-table-visualization-of-kibana/145318/2 "2018-08-21T21:01:56Z")

</div>

I'm a bit confused as to why you're showing column 2 to begin with if it's the same across all of your tables/values... Could you explain? Thanks!

---

<div class="post-metadata">

### Author: ![groverjatin17](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/groverjatin17/32/34657_2.png) [@groverjatin17](https://discuss.elastic.co/u/groverjatin17)
#### Post date: [August 23, 2018, 7:03am UTC](https://discuss.elastic.co/t/how-to-stack-bucket-level-column-in-data-table-visualization-of-kibana/145318/3 "2018-08-23T07:03:25Z")

</div>

Thanks for reply,

The original data in the index involves a field which have open/new as values. These value suggests that the Enquiries are outstanding and yet to be resolved.

I created a Scripted Field which prints/returns Outstanding query instead on New/Open(Enquiries) values. And then i created a sub bucket in the Data table visualization using that field which is the Column 2.

Now i know i can solve this by using the filter as in to take only those docs which contain outstanding query but i wanted to make exact copy of the current Dashboard/Table used in Excel by my org.

Also, even if I remove Column 2 Can we stack the Column1 on the extreme left?

---

<div class="post-metadata">

### Author: ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [August 23, 2018, 6:07pm UTC](https://discuss.elastic.co/t/how-to-stack-bucket-level-column-in-data-table-visualization-of-kibana/145318/4 "2018-08-23T18:07:03Z")

</div>

Do you mind just sharing a screenshot or a sketch for what you're trying to accomplish? I'm missing something here. Sorry!

---

<div class="post-metadata">

### Author: ![groverjatin17](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/groverjatin17/32/34657_2.png) [@groverjatin17](https://discuss.elastic.co/u/groverjatin17)
#### Post date: [August 28, 2018, 4:36am UTC](https://discuss.elastic.co/t/how-to-stack-bucket-level-column-in-data-table-visualization-of-kibana/145318/5 "2018-08-28T04:36:57Z")

</div>

![IMG_20180828_093432](https://us1.discourse-cdn.com/elastic/original/3X/b/b/bbc96490b1c92d7da751cd8a084706aaddedc521.jpeg)

This is hand sketch of what i am looking for.  
In comparison to the former screenshot, here I have stacked the attribute columns(column1,column2) on to left and the metrics columns viewed under specific country(here country is another bucket)

Note:- Don't mind my poor handwriting.

Thanks

---

<div class="post-metadata">

### Author: ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [August 28, 2018, 4:09pm UTC](https://discuss.elastic.co/t/how-to-stack-bucket-level-column-in-data-table-visualization-of-kibana/145318/6 "2018-08-28T16:09:49Z")

</div>

Ahh, this makes sense. Thanks for taking the time to do this!

I can't think of a good way to accomplish this in Kibana at the moment. There are several enhancement requests on GitHub that request this or something like this:

> <https://github.com/elastic/kibana/issues/14601>

  

> <https://github.com/elastic/kibana/issues/9585>

  

> <https://github.com/elastic/kibana/issues/3190>

You might check out [https://github.com/fbaligand/kibana-enhanced-table](https://github.com/fbaligand/kibana-enhanced-table) to see if it can help solve this issue.

---

<div class="post-metadata">

### Author: ![groverjatin17](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/groverjatin17/32/34657_2.png) [@groverjatin17](https://discuss.elastic.co/u/groverjatin17)
#### Post date: [August 30, 2018, 6:38am UTC](https://discuss.elastic.co/t/how-to-stack-bucket-level-column-in-data-table-visualization-of-kibana/145318/7 "2018-08-30T06:38:20Z")

</div>

hi lukas,

I did check all requests and i think the first one is most relatable.  
As a solution someone commented installing "enhanced-table" plugin which have some extra features that might be used as well.

Will try to use it and see if it fits my requirement.  
Then I will mark a comment with plug-in link as an answer.

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: [September 27, 2018, 6:38am UTC](https://discuss.elastic.co/t/how-to-stack-bucket-level-column-in-data-table-visualization-of-kibana/145318/8 "2018-09-27T06:38:40Z")

</div>

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