# Cannot add 10 or more rows to Visualize Library in table view in Kibana

**URL:** https://discuss.elastic.co/t/cannot-add-10-or-more-rows-to-visualize-library-in-table-view-in-kibana/299350
**Category:** Kibana
**Created:** [March 10, 2022, 3:30pm UTC](https://discuss.elastic.co/t/cannot-add-10-or-more-rows-to-visualize-library-in-table-view-in-kibana/299350 "2022-03-10T15:30:05Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Stek\_new](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stek_new/32/102600_2.png) [@Stek\_new](https://discuss.elastic.co/u/Stek_new)
#### Post date: [March 10, 2022, 3:30pm UTC](https://discuss.elastic.co/t/cannot-add-10-or-more-rows-to-visualize-library-in-table-view-in-kibana/299350/1 "2022-03-10T15:30:05Z")

</div>

Hello!

I cannot add 10 or more rows to Visualize Library in table view in Kibana

Steps on how to reproduce the issue:

1. Go Dev Tools and run the following query:

2. Go to **"Stack Management \> Index Pattrens \> Create index pattern"** , find **"logs-my\_app-default"** , select **"--- I don't want to use the time filter ---"** for **"Timestamp field"** and click **"Create index pattern"** button

3. Go at **"Visualize Library \> Create visualization \> Lens"** page abd select **"logs-my\_app-default"** index pattern

4. Start drag-and-dropping all fields one by one.

5. Adding the last 10th field will lead to the following error:

Did not find any errors in logs, however, maybe I missed something and if so just let me know

Screenshots:

 ![1](https://us1.discourse-cdn.com/elastic/original/3X/6/e/6e23fdcbb12fae9e77ebea4276ddc6f673bd388b.png)  
 ![2](https://us1.discourse-cdn.com/elastic/original/3X/5/c/5c48526b70bfb14cb2459a34a436dd14c6c08654.png)

---

<div class="post-metadata">

### 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: [March 10, 2022, 4:31pm UTC](https://discuss.elastic.co/t/cannot-add-10-or-more-rows-to-visualize-library-in-table-view-in-kibana/299350/2 "2022-03-10T16:31:05Z")

</div>

If you check the `Inspect` panel to review the request made by Lens to Elasticsearch you can see that it's trying to do a nested aggregation terms search. You can run the same query from `Dev Tools`:

```auto

GET logs-my_app-default/_search
{
  "aggs": {
    "0": {
      "terms": {
        "field": "event.A",
        "order": {
          "10": "desc"
        },
        "size": 5
      },
      "aggs": {
        "1": {
          "terms": {
            "field": "event.B",
            "order": {
              "10": "desc"
            },
            "size": 3
          },
          "aggs": {
            "2": {
              "terms": {
                "field": "event.C",
                "order": {
                  "10": "desc"
                },
                "size": 3
              },
              "aggs": {
                "3": {
                  "terms": {
                    "field": "event.D",
                    "order": {
                      "10": "desc"
                    },
                    "size": 3
                  },
                  "aggs": {
                    "4": {
                      "terms": {
                        "field": "event.E",
                        "order": {
                          "10": "desc"
                        },
                        "size": 3
                      },
                      "aggs": {
                        "5": {
                          "terms": {
                            "field": "event.F",
                            "order": {
                              "10": "desc"
                            },
                            "size": 3
                          },
                          "aggs": {
                            "6": {
                              "terms": {
                                "field": "event.G",
                                "order": {
                                  "10": "desc"
                                },
                                "size": 3
                              },
                              "aggs": {
                                "7": {
                                  "terms": {
                                    "field": "event.I",
                                    "order": {
                                      "10": "desc"
                                    },
                                    "size": 3
                                  },
                                  "aggs": {
                                    "8": {
                                      "terms": {
                                        "field": "event.J",
                                        "order": {
                                          "10": "desc"
                                        },
                                        "size": 3
                                      },
                                      "aggs": {
                                        "9": {
                                          "terms": {
                                            "field": "event.K",
                                            "order": {
                                              "10": "desc"
                                            },
                                            "size": 3
                                          }
                                        }
                                      }
                                    }
                                  }
                                }
                              }
                            }
                          }
                        }
                      }
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
  },
  "size": 0,
  "fields": [
    {
      "field": "@timestamp",
      "format": "date_time"
    }
  ],
  "script_fields": {},
  "stored_fields": [
    "*"
  ],
  "runtime_mappings": {},
  "_source": {
    "excludes": []
  },
  "query": {
    "bool": {
      "must": [],
      "filter": [],
      "should": [],
      "must_not": []
    }
  }
}

```

And you will get the same error reported in the `Inspect` panel on the `Response` tab.

So this is likely hitting a limit in the number of nested aggregations that you can send to Elasticsearch.

Why do you want to create a table that way? You can save a search in Discover with all the fields enabled and then add it to a dashboard like this:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/5/952c16310211486fcecd5122bbee8c666f170dbf.png)

Does this help?

---

<div class="post-metadata">

### Author: ![Stek\_new](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stek_new/32/102600_2.png) [@Stek\_new](https://discuss.elastic.co/u/Stek_new)
#### Post date: [March 16, 2022, 5:12am UTC](https://discuss.elastic.co/t/cannot-add-10-or-more-rows-to-visualize-library-in-table-view-in-kibana/299350/3 "2022-03-16T05:12:27Z")

</div>

Thanks! Works like a charm!

---

<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 13, 2022, 5:13am UTC](https://discuss.elastic.co/t/cannot-add-10-or-more-rows-to-visualize-library-in-table-view-in-kibana/299350/4 "2022-04-13T05:13:14Z")

</div>

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