# Add columns to aggregated Table visualization

**URL:** <https://discuss.elastic.co/t/add-columns-to-aggregated-table-visualization/212690>\
**Category:** Kibana\
**Created:** [December 20, 2019, 4:45pm UTC](https://discuss.elastic.co/t/add-columns-to-aggregated-table-visualization/212690 "2019-12-20T16:45:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ecc256](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ecc256/32/59815_2.png) [@ecc256](https://discuss.elastic.co/u/ecc256)\
**Post date:** [December 20, 2019, 4:45pm UTC](https://discuss.elastic.co/t/add-columns-to-aggregated-table-visualization/212690/1 "2019-12-20T16:45:26Z")

</div>

Need a little help with Table visualization.

Basically, I have web log with GeoIP column.

I want to show 10 most frequent IPs for a time period (which is super easy with Table visualization).

I want to add few GeoIP columns for these IP, namely [city, county and continent].

The only way I found is to do sub aggregations for the new columns...

Is there way to do join and show it Table visualization? 😊

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [December 24, 2019, 1:34am UTC](https://discuss.elastic.co/t/add-columns-to-aggregated-table-visualization/212690/2 "2019-12-24T01:34:32Z")

</div>

Hi,

Unfortunately doing a join is not possible on table viz. Sub-aggregations is the way to go.

You can check out canvas where you can use elasticsearch-SQL plugin and you might close to what you need. [https://www.elastic.co/guide/en/kibana/current/canvas.html](https://www.elastic.co/guide/en/kibana/current/canvas.html)

Thanks,  
Bhavya

---

<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:** [January 21, 2020, 1:34am UTC](https://discuss.elastic.co/t/add-columns-to-aggregated-table-visualization/212690/3 "2020-01-21T01:34:39Z")

</div>

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