# Increase the lens max results **URL:** \ **Category:** Kibana\ **Tags:** lens\ **Created:** [October 23, 2023, 10:22pm UTC](https://discuss.elastic.co/t/increase-the-lens-max-results/345601 "2023-10-23T22:22:47Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![seanziee](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/seanziee/32/45151_2.png) [@seanziee](https://discuss.elastic.co/u/seanziee)\ **Post date:** [October 23, 2023, 10:22pm UTC](https://discuss.elastic.co/t/increase-the-lens-max-results/345601/1 "2023-10-23T22:22:47Z")
I'd like to increase the number of results on kibana lens data table viz but can't find out how. I regularly export unique ids I have to csv using lens in order to run some custom analysis, etc. I'd like to increase this limit so I don't need to export in 2-3 batches, is this possible? Thanks in advance. ---
**Author:** ![drewdaemon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/drewdaemon/32/97779_2.png) [@drewdaemon](https://discuss.elastic.co/u/drewdaemon)\ **Post date:** [October 24, 2023, 12:39pm UTC](https://discuss.elastic.co/t/increase-the-lens-max-results/345601/2 "2023-10-24T12:39:44Z")
Hi @seanziee , We are tracking this feature request here [[Reporting] Exporting raw data from table-based visualizations · Issue #30982 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/30982). In the meantime, have you considered [using SQL](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-getting-started.html) with a Python ES client? This will return results in table form. Another option would be to copy the Elasticsearch request Lens uses from the Inspect flyout and run it against Elasticsearch directly (outside of Lens), increasing the number of terms. The response you'll get is not in table format, but could be tabified using a custom script. ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [October 25, 2023, 7:29am UTC](https://discuss.elastic.co/t/increase-the-lens-max-results/345601/3 "2023-10-25T07:29:13Z")
> [@seanziee](#): > > I'd like to increase the number of results on kibana lens data table viz but can't find out how. Sorry, what you mean by increase the number of results? Is Lens showing only part of the data and not the entire set? When you download a CSV from a Lens datatable the entire data is exported, it should not be truncated. ---
**Author:** ![seanziee](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/seanziee/32/45151_2.png) [@seanziee](https://discuss.elastic.co/u/seanziee)\ **Post date:** [November 5, 2023, 6:54pm UTC](https://discuss.elastic.co/t/increase-the-lens-max-results/345601/4 "2023-11-05T18:54:50Z")
> [@drewdaemon](#): > > Another option would be to copy the Elasticsearch request Lens uses from the Inspect flyout and run it against Elasticsearch directly (outside of Lens), increasing the number of terms. The response you'll get is not in table format, but could be tabified using a custom script. What I mean is that the max results lens can show for a given aggregation is max 1000. So if I want to see a list of all IPs and their locations, I could only show up to 1000 unique IPs, wheres I'd like to see around 2000 so that I can export. I do a lot of these different aggregations on the fly so doing so with an elastic client isn't ideal for me. Thanks for the suggestion though @drewdaemon ---
**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\ **Post date:** [November 6, 2023, 12:29am UTC](https://discuss.elastic.co/t/increase-the-lens-max-results/345601/5 "2023-11-06T00:29:53Z")
@seanziee What version are you on? I ask because on recent versions you can set number of Top Values (like IPs) up to 10000 ---
**Author:** ![seanziee](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/seanziee/32/45151_2.png) [@seanziee](https://discuss.elastic.co/u/seanziee)\ **Post date:** [November 6, 2023, 9:45pm UTC](https://discuss.elastic.co/t/increase-the-lens-max-results/345601/6 "2023-11-06T21:45:18Z")
I'm on version 7.17.14. Is there a way to increase that number on 7.17? ---
**Author:** ![Priscilla\_Parodi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/priscilla_parodi/32/43047_2.png) [@Priscilla\_Parodi](https://discuss.elastic.co/u/Priscilla_Parodi)\ **Post date:** [November 28, 2023, 8:21pm UTC](https://discuss.elastic.co/t/increase-the-lens-max-results/345601/8 "2023-11-28T20:21:15Z")
Hello @seanziee, no… you can do this on 8.4+ ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [December 26, 2023, 8:21pm UTC](https://discuss.elastic.co/t/increase-the-lens-max-results/345601/9 "2023-12-26T20:21:50Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.