# Kibana datatable visualization not displaying all data rows

**URL:** <https://discuss.elastic.co/t/kibana-datatable-visualization-not-displaying-all-data-rows/98486>\
**Category:** Kibana\
**Created:** [August 27, 2017, 8:02pm UTC](https://discuss.elastic.co/t/kibana-datatable-visualization-not-displaying-all-data-rows/98486 "2017-08-27T20:02:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sarra\_Bouhenni](https://avatars.discourse-cdn.com/v4/letter/s/51bf81/32.png) [@Sarra\_Bouhenni](https://discuss.elastic.co/u/Sarra_Bouhenni)\
**Post date:** [August 27, 2017, 8:02pm UTC](https://discuss.elastic.co/t/kibana-datatable-visualization-not-displaying-all-data-rows/98486/1 "2017-08-27T20:02:16Z")

</div>

Hello,

So I'm working with Kibana 5.5.2 and elasticsearch 5.5.2 to create visualizations and dashboards for our log data.  
I've created a new data table visualization but I can't get all the data of last week to be shown at the same time.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/5/0502fce78ef29124ec3f7989f15570f6129103f1.png)

Without any sub-buckets, I'm getting the number of finished trips equal to 29. (using count aggregation) but when I split rows based on rider\_profile.full\_name (A searchable and aggregatable field which is present in all my 29 records), I get a total of only 14 finished trips displayed for the same date range. Actually, I thought I might have a total of 29 finished trips distributed on multiple rows..

But well, I have noticed that the number of rows doesn't exeed 5. It's like I'm getting the top 5 rows of this datatable. (This is the case for all my other data tables).

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

Is there something I'm missing here? Should I change something in Kibana configuration to display all my datatable rows?

Thanks in advance for your help.

---

<div class="post-metadata">

**Author:** ![Sarra\_Bouhenni](https://avatars.discourse-cdn.com/v4/letter/s/51bf81/32.png) [@Sarra\_Bouhenni](https://discuss.elastic.co/u/Sarra_Bouhenni)\
**Post date:** [August 27, 2017, 8:23pm UTC](https://discuss.elastic.co/t/kibana-datatable-visualization-not-displaying-all-data-rows/98486/2 "2017-08-27T20:23:55Z")

</div>

I have solved this issue, by changing the field size : 5 to another value in my saved objects.

```
{
  "id": "7",
  "enabled": true,
  "type": "terms",
  "schema": "bucket",
  "params": {
    "field": "full_name",
    "size": 100,
    "order": "desc",
    "orderBy": "1",
    "customLabel": "Rider name"
  }

```

My question now is, couldn't there be a way to set the size to all ? I want to get all the values of full\_name !

---

<div class="post-metadata">

**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\
**Post date:** [August 28, 2017, 6:10pm UTC](https://discuss.elastic.co/t/kibana-datatable-visualization-not-displaying-all-data-rows/98486/3 "2017-08-28T18:10:52Z")

</div>

> [@Sarra\_Bouhenni](#):
>
> Is there something I’m missing here? Should I change something in Kibana configuration to display all my datatable rows?
> 
> Thanks in advance for your help.

Hi,  
Have you tried to increase the `size` to a greater number like say ~10000 to get all the values ?

 ![52 AM](https://us1.discourse-cdn.com/elastic/original/3X/4/5/457a3d02693ce3c9ab8795b596901069ebc9e2d0.png)

> **[Terms aggregation | Elasticsearch Guide \[master\] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/master/search-aggregations-bucket-terms-aggregation.html#_size)**

Thanks  
Rashmi

---

<div class="post-metadata">

**Author:** ![Sarra\_Bouhenni](https://avatars.discourse-cdn.com/v4/letter/s/51bf81/32.png) [@Sarra\_Bouhenni](https://discuss.elastic.co/u/Sarra_Bouhenni)\
**Post date:** [September 4, 2017, 12:14pm UTC](https://discuss.elastic.co/t/kibana-datatable-visualization-not-displaying-all-data-rows/98486/4 "2017-09-04T12:14:30Z")

</div>

Hello rashmi, this is exactly what I'm doing now! Thanks.

---

<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:** [October 2, 2017, 12:14pm UTC](https://discuss.elastic.co/t/kibana-datatable-visualization-not-displaying-all-data-rows/98486/5 "2017-10-02T12:14:46Z")

</div>

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