# Any way to show aggregations by columns instead of by rows?

**URL:** https://discuss.elastic.co/t/any-way-to-show-aggregations-by-columns-instead-of-by-rows/42719
**Category:** Kibana
**Created:** [February 25, 2016, 1:24pm UTC](https://discuss.elastic.co/t/any-way-to-show-aggregations-by-columns-instead-of-by-rows/42719 "2016-02-25T13:24:08Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![feicipet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/feicipet/32/8056_2.png) [@feicipet](https://discuss.elastic.co/u/feicipet)
#### Post date: [February 25, 2016, 1:24pm UTC](https://discuss.elastic.co/t/any-way-to-show-aggregations-by-columns-instead-of-by-rows/42719/1 "2016-02-25T13:24:08Z")

</div>

Hi,

In Kibana, I can only create sub-bucket aggregations which is visualized as rows:

 ![](https://us1.discourse-cdn.com/elastic/original/2X/5/5872e09a8e673c83e77898eed4c589014c2bd710.png)

Is there a way to display the aggregation as columns instead?

```
Invitation time CampaignType:Sms CampaignType:Email
Feb 19th 2016 15:45:00.000 3,185 8
Feb 23rd 2016 17:15:00.000 2,229 11
Feb 24th 2016 15:45:00.000 16,523 38

```

Thanks  
Wong

---

<div class="post-metadata">

### Author: ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)
#### Post date: [February 26, 2016, 6:57pm UTC](https://discuss.elastic.co/t/any-way-to-show-aggregations-by-columns-instead-of-by-rows/42719/2 "2016-02-26T18:57:34Z")

</div>

Hi Wong,

No there isn't currently a way to show data in that format in Kibana. But there is a github issue for it.

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

Thanks,  
Lee

---

<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/any-way-to-show-aggregations-by-columns-instead-of-by-rows/42719/3 "2017-07-06T14:01:00Z")

</div>


