# Terms aggragation in datatable not showing all the values

**URL:** https://discuss.elastic.co/t/terms-aggragation-in-datatable-not-showing-all-the-values/232920
**Category:** Kibana
**Created:** [May 16, 2020, 10:58am UTC](https://discuss.elastic.co/t/terms-aggragation-in-datatable-not-showing-all-the-values/232920 "2020-05-16T10:58:28Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![anjilinga](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anjilinga/32/86010_2.png) [@anjilinga](https://discuss.elastic.co/u/anjilinga)
#### Post date: [May 16, 2020, 10:58am UTC](https://discuss.elastic.co/t/terms-aggragation-in-datatable-not-showing-all-the-values/232920/1 "2020-05-16T10:58:28Z")

</div>

Hi,  
I am using datatable to visulaize the data. I want to display all the values from the each document in the index.  
I am using terms aggregation for each field. when i use terms aggregation if any of the field value is null the row is not displaying.

When i select the partial rows display, the row is displaying but the values after the field is empty the remaining fields also displaying as empty.

is there any better way to display the all the documents in datatable ?

---

<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: [June 13, 2020, 10:58am UTC](https://discuss.elastic.co/t/terms-aggragation-in-datatable-not-showing-all-the-values/232920/2 "2020-06-13T10:58:29Z")

</div>

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