# Result limitation **URL:** \ **Category:** Kibana\ **Tags:** dashboard, visualisation\ **Created:** [September 16, 2024, 8:47pm UTC](https://discuss.elastic.co/t/result-limitation/366648 "2024-09-16T20:47:22Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![HermannSamimi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hermannsamimi/32/137155_2.png) [@HermannSamimi](https://discuss.elastic.co/u/HermannSamimi)\ **Post date:** [September 16, 2024, 8:47pm UTC](https://discuss.elastic.co/t/result-limitation/366648/1 "2024-09-16T20:47:22Z")
Hello, I created a dashboard in Kibana, and for a particular visualization, I want to limit the results to 500 documents. Is it possible to display only the last 500 documents? Thanks ---
**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\ **Post date:** [September 17, 2024, 9:01am UTC](https://discuss.elastic.co/t/result-limitation/366648/2 "2024-09-17T09:01:54Z")
What type of visualization are you dealing with? ---
**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\ **Post date:** [September 17, 2024, 9:02am UTC](https://discuss.elastic.co/t/result-limitation/366648/3 "2024-09-17T09:02:08Z")
Added #visualisation ---
**Author:** ![HermannSamimi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hermannsamimi/32/137155_2.png) [@HermannSamimi](https://discuss.elastic.co/u/HermannSamimi)\ **Post date:** [September 17, 2024, 9:16am UTC](https://discuss.elastic.co/t/result-limitation/366648/4 "2024-09-17T09:16:02Z")
Table and bar vertical stacked. ---
**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\ **Post date:** [September 17, 2024, 9:34am UTC](https://discuss.elastic.co/t/result-limitation/366648/5 "2024-09-17T09:34:40Z")
And you want to limit the results **before** adding it to the visualization so you want to create a chart from the last 500 documents based on a field sorting criteria? ---
**Author:** ![HermannSamimi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hermannsamimi/32/137155_2.png) [@HermannSamimi](https://discuss.elastic.co/u/HermannSamimi)\ **Post date:** [September 17, 2024, 10:17am UTC](https://discuss.elastic.co/t/result-limitation/366648/6 "2024-09-17T10:17:40Z")
That's correct. Let's say I'm gonna have a visual including last 500 documents(i.e source.email(vertical) and count of records(horizontal)) ---
**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\ **Post date:** [September 17, 2024, 10:41am UTC](https://discuss.elastic.co/t/result-limitation/366648/7 "2024-09-17T10:41:29Z")
I'm afraid you can't do that with Lens, at this moment. I understand as soon as we have ES|QL available in Lens, you'll be able to feed a query like this to your chart to render just the latest 100 documents ```plaintext FROM kibana_sample_data_flights | WHERE timestamp is not null | SORT timestamp DESC | LIMIT 100 | KEEP timestamp, Carrier ``` In the meantime, you may want to give [Vega](https://www.elastic.co/guide/en/kibana/current/vega.html#vega-queries) a try since you can write a full query, including the `size` parameter to limit results. @Marco_Liberati may keep me honest here or provide further instructions, in case I'm missing something. ---
**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:** [September 17, 2024, 12:45pm UTC](https://discuss.elastic.co/t/result-limitation/366648/8 "2024-09-17T12:45:52Z")
It is possible to create a chart with ES|QL in dashboard with a query like that ---
**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\ **Post date:** [September 17, 2024, 1:47pm UTC](https://discuss.elastic.co/t/result-limitation/366648/9 "2024-09-17T13:47:48Z")
I knew I was missing something, thanks for the pointer Marco! ES|QL visualizations need to be created from the Dashboard **Add panel** button as shown below: ![esql](https://us1.discourse-cdn.com/elastic/original/3X/6/a/6aa8069f4dd439d536ef89f925ea4e4e47713b49.gif) ---
**Author:** ![HermannSamimi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hermannsamimi/32/137155_2.png) [@HermannSamimi](https://discuss.elastic.co/u/HermannSamimi)\ **Post date:** [September 17, 2024, 9:22pm UTC](https://discuss.elastic.co/t/result-limitation/366648/10 "2024-09-17T21:22:59Z")
Thanks. Would you clarify from which data sources i can fetch data? index, datastream, data view? ---
**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\ **Post date:** [September 18, 2024, 1:08am UTC](https://discuss.elastic.co/t/result-limitation/366648/11 "2024-09-18T01:08:14Z")
Data Views are not supported since they are a Kibana abstraction. Take a look at the documentation for details > **[ES|QL commands | Elasticsearch Guide \[8.15\] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/esql-commands.html#esql-from)**