# Question about Split Table when making a Table Visualization

**URL:** https://discuss.elastic.co/t/question-about-split-table-when-making-a-table-visualization/167234
**Category:** Kibana
**Created:** [February 6, 2019, 6:32am UTC](https://discuss.elastic.co/t/question-about-split-table-when-making-a-table-visualization/167234 "2019-02-06T06:32:55Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![AMiura](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@AMiura](https://discuss.elastic.co/u/AMiura)
#### Post date: [February 6, 2019, 6:32am UTC](https://discuss.elastic.co/t/question-about-split-table-when-making-a-table-visualization/167234/1 "2019-02-06T06:32:55Z")

</div>

We're on Kibana 6.6. My Firewall Guy has asked me to build him some Top Talkers and Listeners visualizations for our proof of concept display of the Elastic Stack. I've thought I'd be nice and build him a table of what the Top Talkers are most frequently talking to but every time I make the split table size more than 1 I get a lot more than the number listed.

```
Table Visualization Settings:
  Metrics
     Metric: Count
  Buckets
     Split Rows
        Aggregation: Terms
        Field: receiving_host.keyword
        Order By: metric: Count
        Order: Descend
        Size: 20
     Split Table
        Columns
        Sub Aggregation: Terms
        Field: sending_host.keyword
        Order By: Metric: Count
        Order: Descend
        Size: *

```

When I set the spot marked with \* to 1 I get 1 table  
When I set the spot marked with \* to 2 I get 8 tables  
When I set the spot marked with \* to 3 I get 11 tables  
When I set the spot marked with \* to 4 I get 18 tables  
And so on and so forth.

Is it supposed to do that? If so, what's the formula for how many tables it's generating? I'd kind of like to generate 4 or 5 instead of 8

---

<div class="post-metadata">

### Author: ![AMiura](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@AMiura](https://discuss.elastic.co/u/AMiura)
#### Post date: [February 6, 2019, 8:15am UTC](https://discuss.elastic.co/t/question-about-split-table-when-making-a-table-visualization/167234/2 "2019-02-06T08:15:10Z")

</div>

Found a solution to my problem of number of tables I want to see. Moving Split Table above Split Rows got me the correct number of tables. I am still curious as to how Kibana was deciding how many tables to generate though

---

<div class="post-metadata">

### Author: ![Aaron\_Caldwell](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron_caldwell/32/45755_2.png) [@Aaron\_Caldwell](https://discuss.elastic.co/u/Aaron_Caldwell)
#### Post date: [February 6, 2019, 5:46pm UTC](https://discuss.elastic.co/t/question-about-split-table-when-making-a-table-visualization/167234/3 "2019-02-06T17:46:59Z")

</div>

Hello Amanda,

Glad you found a solution. FWIW, we're aware this logic is confusing and changes are in progress for future versions:

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

Thanks,  
Aaron

---

<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: [March 6, 2019, 5:47pm UTC](https://discuss.elastic.co/t/question-about-split-table-when-making-a-table-visualization/167234/4 "2019-03-06T17:47:10Z")

</div>

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