# Kibana table sample size **URL:** \ **Category:** Kibana\ **Created:** [September 13, 2020, 6:46pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449 "2020-09-13T18:46:17Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![AditiKhalatkar](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@AditiKhalatkar](https://discuss.elastic.co/u/AditiKhalatkar)\ **Post date:** [September 13, 2020, 6:46pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449/1 "2020-09-13T18:46:17Z")
How much can be the maximum value for discover:sampleSize in Kibana/Advanced Settings? I have tried setting it to 10000 because of a few use cases (since my table crashes because of too many rows at times). Also, I saw a warning saying "You can break stuff here", so thought of asking. Kindly guide. Thanks. ---
**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Post date:** [September 13, 2020, 7:23pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449/2 "2020-09-13T19:23:28Z")
if you have big table. do't do table viz. go to discover add a require colum and save that as serarch. and then insert that search in to your dashboard and it won't break. I have done that for one my my big table. ---
**Author:** ![AditiKhalatkar](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@AditiKhalatkar](https://discuss.elastic.co/u/AditiKhalatkar)\ **Post date:** [September 13, 2020, 9:33pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449/3 "2020-09-13T21:33:14Z")
Thanks for the quick reply @elasticforme. It works! Appreciate it. Do you know by any change if I can limit the number of rows inside discover component (may be to 10) and also give an alias name to the columns? Thanks again. ---
**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\ **Post date:** [September 13, 2020, 9:40pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449/4 "2020-09-13T21:40:24Z")
1. Alias you can do a scripted field but that is probably not the best idea if you are looking for performance. But you can add a new field with another value and rename the column. 2. Believe the hardcoded minimum value for rows is 50 (if you are talking about pagination) but if you want it above 50 I think there is an option in advanced settings. ---
**Author:** ![AditiKhalatkar](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@AditiKhalatkar](https://discuss.elastic.co/u/AditiKhalatkar)\ **Post date:** [September 13, 2020, 10:54pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449/5 "2020-09-13T22:54:47Z")
Thanks for the quick reply @aaron-nimocks. Sure, will try out the solutions. It appears though discover table is sort of editable. Do you know any way we can lock the number of columns on it? Thanks. ---
**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\ **Post date:** [September 13, 2020, 11:02pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449/6 "2020-09-13T23:02:28Z")
Whatever columns are selected before you save the search is what is maintained. Add, remove, sort, and order them first. Then save it. ---
**Author:** ![AditiKhalatkar](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@AditiKhalatkar](https://discuss.elastic.co/u/AditiKhalatkar)\ **Post date:** [September 14, 2020, 5:15pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449/7 "2020-09-14T17:15:50Z")
Got the column number fixed. Sorry got stuck again. I totally forgot about the export buttons on datatable, is there a way to the same with saved search? Thanks. ---
**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\ **Post date:** [September 14, 2020, 5:21pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449/8 "2020-09-14T17:21:19Z")
@AditiKhalatkar it's a little different on the dashboard than a data table, but click the 3 dots on the top right of the table and you get the below menu. ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/9/89572f8ff54bad628aba1587a33c5b5dd3fc7a89.png) ---
**Author:** ![AditiKhalatkar](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@AditiKhalatkar](https://discuss.elastic.co/u/AditiKhalatkar)\ **Post date:** [September 14, 2020, 5:26pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449/9 "2020-09-14T17:26:24Z")
@aaron-nimocks Thanks for the picture. I think I might be using some other version. Mine gives 2 options only. Please find the below screenshot for reference. ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/2/3210f5bbd0ad0602a310dc3a2f22c83b00788fdf.png) Also, I found one relevant post where we would add "Reporting" option on Dashboard using x-pack, will that help me download the table? ---
**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\ **Post date:** [September 14, 2020, 5:30pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449/10 "2020-09-14T17:30:12Z")
@AditiKhalatkar Below is a saved search on a dashboard. The 3 dots only give you those 2 options? I know View Underlying Data is new (I think 7.9) but download CSV has been there for awhile I believe. What version are you using? ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/c/6c3abd310cb48a888dafb32377484c8b8148fb18.png) ---
**Author:** ![AditiKhalatkar](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@AditiKhalatkar](https://discuss.elastic.co/u/AditiKhalatkar)\ **Post date:** [September 14, 2020, 5:32pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449/11 "2020-09-14T17:32:22Z")
@aaron-nimocks Mine is a bit older version (6.8). Is it because of that? ---
**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\ **Post date:** [September 14, 2020, 5:35pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449/12 "2020-09-14T17:35:52Z")
@AditiKhalatkar it is. Looked it up and it was a [7.3 release](https://www.elastic.co/guide/en/kibana/7.x/release-notes-7.3.0.html). Would need to upgrade to get that option. ---
**Author:** ![AditiKhalatkar](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@AditiKhalatkar](https://discuss.elastic.co/u/AditiKhalatkar)\ **Post date:** [September 14, 2020, 5:38pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449/13 "2020-09-14T17:38:29Z")
@aaron-nimocks Thanks for the quick help. Appreciate it! Will upgrading Kibana + Elasticsearch break anything? Also, is it safe since 6.8 seemed more stable since it would only depreciated once 8.0 comes into picture? (Let me know if I should create a separate thread for this question) ---
**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\ **Post date:** [September 14, 2020, 5:43pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449/14 "2020-09-14T17:43:05Z")
@AditiKhalatkar I would recommend going to 7.3 if you need that functionality. Probably best to get 7.3.2 since it address bug fixes in 7.3. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [October 12, 2020, 5:43pm UTC](https://discuss.elastic.co/t/kibana-table-sample-size/248449/15 "2020-10-12T17:43:09Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.