# Kibana data-table visualization not displaying all data rows **URL:** \ **Category:** Kibana\ **Created:** [July 7, 2023, 7:06am UTC](https://discuss.elastic.co/t/kibana-data-table-visualization-not-displaying-all-data-rows/337861 "2023-07-07T07:06:38Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![mohanss08](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohanss08/32/82297_2.png) [@mohanss08](https://discuss.elastic.co/u/mohanss08)\ **Post date:** [July 7, 2023, 7:06am UTC](https://discuss.elastic.co/t/kibana-data-table-visualization-not-displaying-all-data-rows/337861/1 "2023-07-07T07:06:38Z")
I’m trying to create a `Data Table` visualization and I have below issue. My `buckets` selections as follows. ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/4/1420fadad585db0ee02943fa062d4b294796ecef.png) In `discover` page, i can able to view the data , each fields value and its rows without any problem. But in `visualize library` page for my `Description` field it doesn’t show expect single row. Without my `Description` field i can able to load all rows. Since size I have selected (5000) in aggregation still not sure why it is not showing all the rows. Can I know should I change something in kibana configurations to display all my data-table rows? Thanks in advance for the help! ---
**Author:** ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)\ **Post date:** [July 7, 2023, 9:09am UTC](https://discuss.elastic.co/t/kibana-data-table-visualization-not-displaying-all-data-rows/337861/2 "2023-07-07T09:09:27Z")
Hey, so you have a metric and split row with terms and you only see one row? Can you check the response from ES. You can see it by clicking the inspect button. Does your time span is the same you are using in Discover? ---
**Author:** ![mohanss08](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohanss08/32/82297_2.png) [@mohanss08](https://discuss.elastic.co/u/mohanss08)\ **Post date:** [July 7, 2023, 9:30am UTC](https://discuss.elastic.co/t/kibana-data-table-visualization-not-displaying-all-data-rows/337861/3 "2023-07-07T09:30:10Z")
Hello @Stratoula_Kalafateli, You are right and even the response from `inspect button` also i can i see only one row. For your information, My `description` column contains data in below format. ```auto [S-Name] Frank Van Puffelen. [Area/Pin] San Francisco, CA. [Locality/Status/Population] Northern California. [City Zipcode#] 012345678 [Relevant Details] Center for flagship. [Department] Staff services. [Peninsula] Pacific Ocean. [Services and resources] ADA information. [Created By] Alvaro Alfaro. Activities:Transportation,Parking:All_Access *****Apply Online: https://stuedu.org/sfg/7894561123***** ``` ---
**Author:** ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)\ **Post date:** [July 7, 2023, 9:33am UTC](https://discuss.elastic.co/t/kibana-data-table-visualization-not-displaying-all-data-rows/337861/4 "2023-07-07T09:33:18Z")
Hmm I see, this is the reason. For this format is difficult for ES to get the different terms. Discover is not running any aggregation. Just displays the values as they are in the index, this is why you see your data in Discover. ---
**Author:** ![mohanss08](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohanss08/32/82297_2.png) [@mohanss08](https://discuss.elastic.co/u/mohanss08)\ **Post date:** [July 7, 2023, 9:42am UTC](https://discuss.elastic.co/t/kibana-data-table-visualization-not-displaying-all-data-rows/337861/5 "2023-07-07T09:42:10Z")
Okay. At present I'm using `ELK - 8.6.1` version. So with latest version (Or) any possible workaround can help to view the data in visualization section? ---
**Author:** ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)\ **Post date:** [July 7, 2023, 9:46am UTC](https://discuss.elastic.co/t/kibana-data-table-visualization-not-displaying-all-data-rows/337861/6 "2023-07-07T09:46:52Z")
No I am afraid that with this format is difficult for ES to extract the terms tbh. I think that this info that exists on the description should be extracted in different fields. So one field the Name, one field the area, one field the zip code etc. ---
**Author:** ![mohanss08](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohanss08/32/82297_2.png) [@mohanss08](https://discuss.elastic.co/u/mohanss08)\ **Post date:** [July 14, 2023, 5:25am UTC](https://discuss.elastic.co/t/kibana-data-table-visualization-not-displaying-all-data-rows/337861/8 "2023-07-14T05:25:18Z")
@Stratoula_Kalafateli - Since one row field that i'm able to view in data-table has `242` characters. Whereas the other rows `description` field are having more than `256` characters. So i had executed ` "ignore_above": 512000` for `description` field but still `description` field values are not loading. So further any changes do i need to make? Please confirm. Thanks in advance. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [August 11, 2023, 5:26am UTC](https://discuss.elastic.co/t/kibana-data-table-visualization-not-displaying-all-data-rows/337861/9 "2023-08-11T05:26:15Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.