# Error in visualization \[lens\_merge\_tables\] \> \[esaggs\] \> Cannot read property 'aggConfig' of undefined

**URL:** <https://discuss.elastic.co/t/error-in-visualization-lens-merge-tables-esaggs-cannot-read-property-aggconfig-of-undefined/258544>\
**Category:** Kibana\
**Created:** [December 14, 2020, 7:32am UTC](https://discuss.elastic.co/t/error-in-visualization-lens-merge-tables-esaggs-cannot-read-property-aggconfig-of-undefined/258544 "2020-12-14T07:32:41Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![zhirong\_tong](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zhirong_tong/32/80787_2.png) [@zhirong\_tong](https://discuss.elastic.co/u/zhirong_tong)\
**Post date:** [December 14, 2020, 7:32am UTC](https://discuss.elastic.co/t/error-in-visualization-lens-merge-tables-esaggs-cannot-read-property-aggconfig-of-undefined/258544/1 "2020-12-14T07:32:41Z")

</div>

Hi all, I am using ELK 7.5, facing an issue with the Lens in visualization, that is "[lens\_merge\_tables] \> [esaggs] \> Cannot read property 'aggConfig' of undefined", it happens when I drag fields into the panel of Lens. Since the data popped in was from "kibana\_sample\_data\_ecommerce", I guess this was not a data problem.

 ![cannot_read_property_'appConfig'](https://us1.discourse-cdn.com/elastic/original/3X/2/b/2b77a71fcfec9d0a8ffce0a8582d4de445d4ed18.png)

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [December 14, 2020, 3:12pm UTC](https://discuss.elastic.co/t/error-in-visualization-lens-merge-tables-esaggs-cannot-read-property-aggconfig-of-undefined/258544/2 "2020-12-14T15:12:24Z")

</div>

How's x axis, y axis and break down by configured (which functions are you using)? Also, which version of Kibana are you running?

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [December 15, 2020, 2:11pm UTC](https://discuss.elastic.co/t/error-in-visualization-lens-merge-tables-esaggs-cannot-read-property-aggconfig-of-undefined/258544/5 "2020-12-15T14:11:48Z")

</div>

What's used for the "Break down by" dimension? In general a lot changed in the last few versions in Lens, if that's possible for you try upgrading your stack to see whether the problem persists.

Can you export the saved object from "Management" and paste it here?

---

<div class="post-metadata">

**Author:** ![zhirong\_tong](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zhirong_tong/32/80787_2.png) [@zhirong\_tong](https://discuss.elastic.co/u/zhirong_tong)\
**Post date:** [December 16, 2020, 1:09am UTC](https://discuss.elastic.co/t/error-in-visualization-lens-merge-tables-esaggs-cannot-read-property-aggconfig-of-undefined/258544/7 "2020-12-16T01:09:29Z")

</div>

```auto
{
  "name" : "jd-bj-bjy-elasticsearch008",
  "cluster_name" : "elk_bjy",
  "cluster_uuid" : "LPCe-w6sSCiI933GGNMXrA",
  "version" : {
    "number" : "7.5.0",
    "build_flavor" : "default",
    "build_type" : "rpm",
    "build_hash" : "e9ccaed468e2fac2275a3761849cbee64b39519f",
    "build_date" : "2019-11-26T01:06:52.518245Z",
    "build_snapshot" : false,
    "lucene_version" : "8.3.0",
    "minimum_wire_compatibility_version" : "6.8.0",
    "minimum_index_compatibility_version" : "6.0.0-beta1"
  },
  "tagline" : "You Know, for Search"
}

```

Sure I will install a newer version and see.

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [December 16, 2020, 8:09am UTC](https://discuss.elastic.co/t/error-in-visualization-lens-merge-tables-esaggs-cannot-read-property-aggconfig-of-undefined/258544/8 "2020-12-16T08:09:02Z")

</div>

I think we had a misunderstanding, the saved object you posted is the index pattern, not the Lens visualization.

---

<div class="post-metadata">

**Author:** ![zhirong\_tong](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zhirong_tong/32/80787_2.png) [@zhirong\_tong](https://discuss.elastic.co/u/zhirong_tong)\
**Post date:** [December 16, 2020, 8:52am UTC](https://discuss.elastic.co/t/error-in-visualization-lens-merge-tables-esaggs-cannot-read-property-aggconfig-of-undefined/258544/9 "2020-12-16T08:52:20Z")

</div>

```auto
{
    "attributes": {
        "expression": "kibana\n| kibana_context query=\"{\\\"query\\\":\\\"\\\",\\\"language\\\":\\\"kuery\\\"}\" filters=\"[]\"\n| lens_merge_tables layerIds=\"457d86b5-2310-42eb-86b5-6bc7b36e6005\" \n tables={esaggs index=\"ff959d40-b880-11e8-a6d9-e546fe2bba5f\" metricsAtAllLevels=false partialRows=false includeFormatHints=true aggConfigs={lens_auto_date aggConfigs=\"[{\\\"id\\\":\\\"651741c1-903e-482b-aba0-211ee1d19422\\\",\\\"enabled\\\":true,\\\"type\\\":\\\"terms\\\",\\\"schema\\\":\\\"segment\\\",\\\"params\\\":{\\\"field\\\":\\\"customer_id\\\",\\\"orderBy\\\":\\\"_key\\\",\\\"order\\\":\\\"asc\\\",\\\"size\\\":3,\\\"otherBucket\\\":false,\\\"otherBucketLabel\\\":\\\"Other\\\",\\\"missingBucket\\\":false,\\\"missingBucketLabel\\\":\\\"Missing\\\"}}]\"} | lens_rename_columns idMap=\"{\\\"col-0-651741c1-903e-482b-aba0-211ee1d19422\\\":{\\\"label\\\":\\\"customer_id 的排名最前值\\\",\\\"dataType\\\":\\\"string\\\",\\\"operationType\\\":\\\"terms\\\",\\\"scale\\\":\\\"ordinal\\\",\\\"suggestedPriority\\\":1,\\\"sourceField\\\":\\\"customer_id\\\",\\\"isBucketed\\\":true,\\\"params\\\":{\\\"size\\\":3,\\\"orderBy\\\":{\\\"type\\\":\\\"alphabetical\\\"},\\\"orderDirection\\\":\\\"asc\\\"},\\\"id\\\":\\\"651741c1-903e-482b-aba0-211ee1d19422\\\"}}\"}\n| lens_xy_chart xTitle=\"customer_id 的排名最前值\" yTitle=\"y\" legend={lens_xy_legendConfig isVisible=true position=\"right\"} \n layers={lens_xy_layer layerId=\"457d86b5-2310-42eb-86b5-6bc7b36e6005\" hide=false xAccessor=\"651741c1-903e-482b-aba0-211ee1d19422\" yScaleType=\"ordinal\" xScaleType=\"ordinal\" isHistogram=false splitAccessor=undefined seriesType=\"bar_stacked\" columnToLabel=\"{}\"}",
        "state": {
            "datasourceMetaData": {
                "filterableIndexPatterns": [
                    {
                        "id": "ff959d40-b880-11e8-a6d9-e546fe2bba5f",
                        "title": "kibana_sample_data_ecommerce"
                    }
                ]
            },
            "datasourceStates": {
                "indexpattern": {
                    "currentIndexPatternId": "ff959d40-b880-11e8-a6d9-e546fe2bba5f",
                    "layers": {
                        "457d86b5-2310-42eb-86b5-6bc7b36e6005": {
                            "columnOrder": [
                                "651741c1-903e-482b-aba0-211ee1d19422"
                            ],
                            "columns": {
                                "651741c1-903e-482b-aba0-211ee1d19422": {
                                    "dataType": "string",
                                    "isBucketed": true,
                                    "label": " Top Value of customer_id ",
                                    "operationType": "terms",
                                    "params": {
                                        "orderBy": {
                                            "type": "alphabetical"
                                        },
                                        "orderDirection": "asc",
                                        "size": 3
                                    },
                                    "scale": "ordinal",
                                    "sourceField": "customer_id",
                                    "suggestedPriority": 1
                                }
                            },
                            "indexPatternId": "ff959d40-b880-11e8-a6d9-e546fe2bba5f"
                        }
                    }
                }
            },
            "filters": [
                
            ],
            "query": {
                "language": "kuery",
                "query": ""
            },
            "visualization": {
                "layers": [
                    {
                        "accessors": [
                            "d6dbb675-d41c-4a3d-9d63-3592f0c78c23"
                        ],
                        "layerId": "457d86b5-2310-42eb-86b5-6bc7b36e6005",
                        "position": "top",
                        "seriesType": "bar_stacked",
                        "showGridlines": false,
                        "splitAccessor": "70085991-6a75-44ae-9912-91c02200956c",
                        "xAccessor": "651741c1-903e-482b-aba0-211ee1d19422"
                    }
                ],
                "legend": {
                    "isVisible": true,
                    "position": "right"
                },
                "preferredSeriesType": "bar_stacked",
                "title": "Empty XY chart"
            }
        },
        "title": "lensWithError",
        "visualizationType": "lnsXY"
    },
    "id": "c45d2ca0-3f7b-11eb-a881-63223322643e",
    "references": [
        
    ],
    "type": "lens",
    "updated_at": "2020-12-16T08:50:37.290Z",
    "version": "WzIxODIsMTBd"
}{
    "exportedCount": 1,
    "missingRefCount": 0,
    "missingReferences": [
        
    ]
}

```

---

<div class="post-metadata">

**Author:** ![zhirong\_tong](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zhirong_tong/32/80787_2.png) [@zhirong\_tong](https://discuss.elastic.co/u/zhirong_tong)\
**Post date:** [December 16, 2020, 8:54am UTC](https://discuss.elastic.co/t/error-in-visualization-lens-merge-tables-esaggs-cannot-read-property-aggconfig-of-undefined/258544/10 "2020-12-16T08:54:39Z")

</div>

Sorry now I understand and export it , named it with the title 'lensWithError'.  
Could you kindly take a see of it?

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [December 16, 2020, 8:57am UTC](https://discuss.elastic.co/t/error-in-visualization-lens-merge-tables-esaggs-cannot-read-property-aggconfig-of-undefined/258544/11 "2020-12-16T08:57:33Z")

</div>

Ah, I see, thanks for the saved object. You need to add something to the y axis as well (like the "Count of records"), otherwise the chart won't render. The error message improved a lot in more recent versions 🙂

---

<div class="post-metadata">

**Author:** ![zhirong\_tong](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zhirong_tong/32/80787_2.png) [@zhirong\_tong](https://discuss.elastic.co/u/zhirong_tong)\
**Post date:** [December 16, 2020, 9:12am UTC](https://discuss.elastic.co/t/error-in-visualization-lens-merge-tables-esaggs-cannot-read-property-aggconfig-of-undefined/258544/12 "2020-12-16T09:12:52Z")

</div>

Thank you, now it works.

---

<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:** [January 13, 2021, 9:12am UTC](https://discuss.elastic.co/t/error-in-visualization-lens-merge-tables-esaggs-cannot-read-property-aggconfig-of-undefined/258544/13 "2021-01-13T09:12:56Z")

</div>

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