# Kibana Data table size limit

**URL:** <https://discuss.elastic.co/t/kibana-data-table-size-limit/77659>\
**Category:** Kibana\
**Created:** [March 7, 2017, 1:01pm UTC](https://discuss.elastic.co/t/kibana-data-table-size-limit/77659 "2017-03-07T13:01:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Timur](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/timur/32/16154_2.png) [@Timur](https://discuss.elastic.co/u/Timur)\
**Post date:** [March 7, 2017, 1:01pm UTC](https://discuss.elastic.co/t/kibana-data-table-size-limit/77659/1 "2017-03-07T13:01:14Z")

</div>

I'm trying to limit number of records aggregated by Data table visualization to 500 first results.  
I've updated kibanaSavedObjectMeta.searchSourceJSON of my saved visualization object as follows:

```
{
  "index": "logstash-*",
  "size": 500,
  "query": {
    "query_string": {
      "query": "*",
      "analyze_wildcard": true
    }
  },
  "filter": []
}

```

i.e. added "size": 500 parameter, but it doesn't work at all. Is there any way to do it? I need to apply limit before\_aggregation, not after like SQL limit keyword does.

---

<div class="post-metadata">

**Author:** ![Joe\_Fleming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_fleming/32/3561_2.png) [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)\
**Post date:** [March 9, 2017, 9:07pm UTC](https://discuss.elastic.co/t/kibana-data-table-size-limit/77659/2 "2017-03-09T21:07:17Z")

</div>

What do your aggregations look like for the definition of that visualization? You can do the limit as part of the first aggregation by setting the order to descending and setting the limit to 500.

---

<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:** [April 6, 2017, 9:07pm UTC](https://discuss.elastic.co/t/kibana-data-table-size-limit/77659/3 "2017-04-06T21:07:19Z")

</div>

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